How do I alter a published PBI data set?

[rihoughton]

When I connect to a published PBI data set in PBI desktop, I have no ability to alter the data model.  Everything is greyed out.

I know that this technically cannot be done, but what steps do I need to go through to effectively alter the published PBI data set?

[v-henryk-mstf · Accepted solution]

Hi @rihoughton ,

According to your description, you first need to understand the concept of dataset on powerbi service. For different connection modes (import, direct query), the dataset is different.

Import mode loads the data from the data source to the powerbi, while direct query mode loads only the metadata source of the data source and other information.
Therefore, if you connect to a dataset as a data source in powerbi desktop, you need to determine its connection mode and just be able to customize the report based on this data source. In addition, if you want to make changes to the data model, you need to be able to access the corresponding data source.

Downloading pbix files from the service also has the following restrictions.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

You need to download the pbix from the Service (under the File pull down on the report page if you have access), modify it, and re-publish it.

Pat