Transform Data (replaced values) in power bi service.

[T-Pan]

Hello,

I have uploaded a pbix file in power bi service and i have given access to some managers in this report. Now i want to transform some data (replaced values in power query). Can i do this in power bi service, and if not, can i download the file and whatever changes i make in desktop automatically applied to the report in power bi service?

[v-xiaoyan-msft · Accepted solution]

Hi @T-Pan ,

Power BI Service doesn’t support data transformation.

To make changes to your data, you would need to download the PBIX file, make the changes in Power BI Desktop, and then publish it again.

Please note that you should always use the latest version of Power BI Desktop when you open downloaded files. Also, there are some limitations to downloading the PBIX file.

Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn

For more information，you may refer to：

Solved: Edit a report uploaded to powerbi Service in Power... - Microsoft Fabric Community

Best regards.
Community Support Team_Caitlyn

[amustafa]

In Power BI service you can now open the Symentic Model (AKA Data Model) and update measures and columns. However you cannot open the Power Query. This has to be done in Desktop and re-publishing it to the service. 

Going forward it would be better to create a dataflow in Power BI service and create a report using the Dataflow. I'm saying this because you'll have more requestes like these in the future and it will save you time updating the data model. Cheers!

[T-Pan]

So if i use datadlows as my data source, i would be able to do transformations in power bi service which now I can't. Sorry if my question seems stupid, but i have never used Dataflows and I don't know how dataflows work.

[amustafa]

Feel free to connect with me on Teams and I'd be happy to walk you through the Dataflows. My ID is mustafa@ms365.com.pk