when the data view doest show in the desktop

[db042190]

Hi from my experience when i download from the service to the dektop the semantic model (dataset) , i've always wondered why the data view doesnt show.   i've always muddled thru a workaround .

similarly a peer of mine asked today if going to the modeling tab where the new column icon is GREYED out for him is the path he wants.  He generally takes copies of pbix's from file shares.   He too doesnt see the data view when copying this way into the desktop.

can the community use what i've presented here to give us a more straightforward way of getting past this when often the data view is a more comfortable/familiar path to what we are trying to accomplish?

[rajendraongole1 · Accepted solution]

Hi @db042190 - you can go to the Modeling tab and check if it shows the mode as DirectQuery or Live Connection at the bottom right corner.
2. Change the Mode (if DirectQuery):
If possible, switch the mode to Import to enable data modeling features.disconnecting from the current data source.
Re-importing the data into the PBIX file.
Be aware that this will import the data into Power BI Desktop, which might not be feasible for very large datasets.
If the PBIX file relies on a shared dataset in the Power BI Service or another source, you may need to request access to the underlying data or dataset to modify it.
4. Consider a New PBIX File:
If the file's setup can't be modified, create a new PBIX file and import the required data from the source yourself. This ensures you have full control over the data model.
5. Work in the Query Editor:
For cases where the Data view is inaccessible, consider using the Query Editor (Transform Data). This interface allows you to make many of the same transformations as the Data view, though it doesn't support creating calculated columns directly.