The other file has 8 tables and never had the data view icon available.
Power bi data model icon.
This article targets import data modelers working with power bi desktop.
Hi there brand new to power bi.
2 minutes to read.
Navigate to the home ribbon in power bi desktop.
It s an important model design topic that s essential to delivering intuitive accurate and optimal models.
For a deeper discussion on optimal model design including table roles and relationships see the understand star schema and the importance for power bi article.
Select the list item import theme from the drop down menu.
2 minutes to read.
I have another power bi report where i have no problem i can see the data view icon that one has two tables and a third that i created from those two.
2 minutes to read.
I have created some shared datasets for some of our analysts to use and published them with proper permissions i believe.
This view can be especially helpful when your model has complex relationships between many tables.
Work with model view in power bi desktop.
Data view helps you inspect explore and understand data in your power bi desktop model.
Got going yesterday linking queried sql tables in desktop power bi but i can no longer view the data view.
I am fairly new to power bi.
It s different from how you view tables columns and data in power query editor with data view you re looking at your data after it has been loaded into the model.
Work with data view in power bi desktop.
Work with modeling view in power bi desktop.
With modeling view in power bi desktop you can view and work with complex datasets that contain many tables.
If i open a blank power bi instance i see all three options on the left relationships report.
The open file dialog box will open.
We ve noticed that when we try and user power bi desktop to connect to these shared datasets the data and model icons are missing from the left hand navigation.
Model view shows all of the tables columns and relationships in your model.
By default power bi maintains a single cache for every tile but if you use dynamic security to restrict data access based on user roles as covered in the article row level security rls with power bi then power bi must maintain a cache for every role and every tile.
To access modeling view select the modeling view icon found on the left side of power bi desktop as shown in the following image.
The data view option is available to me when i open a new file but when i open another file it is not there.
To add these additional icons follow these steps.
Excel power user and capable enough in sql.
Select the model icon near the side of the window to see a view of the existing.
Discover how to navigate this intuitive tool and get to grips with power bi s data model and report views.
The number of tile caches multiplies by the number of roles.