Forum Discussion
How to transform data from Power BI service?
I have connected to data in Power BI desktop from the online service - is there a way I can perform transformations on this data in the desktop?
Thank you 🙂
Hi Anonymous ,
By default, when you connect to a dataset in Power BI Service, the connection mode is Live Connection. This live connection connects to your data model, so you can't arbitrarily enter Power Query to transform data.
And you may alreday know that a dataset with live connection can changed to DirectQuery.
However, when working with DirectQuery for Power BI datasets and Analysis Services, the connection to a Power BI dataset won't be shown in Power Query.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Therefore, currently, you cannot do data transformation for datasets in Power Query.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
If I understand correctly, are you connecting to a Power Bi service dataset from Power BI Desktop?
In order to do this you would have to edit the original dataset or duplicate it, downloading the pbix of the dataset first as long as you have permissions to do so. You could also prefer the use of a dataflow
You cannot directly edit a dataset already hung with a connection from desktop because a live connection is generated and does not allow transformations in Power Query,
Hi Anonymous ,
By default, when you connect to a dataset in Power BI Service, the connection mode is Live Connection. This live connection connects to your data model, so you can't arbitrarily enter Power Query to transform data.
And you may alreday know that a dataset with live connection can changed to DirectQuery.
However, when working with DirectQuery for Power BI datasets and Analysis Services, the connection to a Power BI dataset won't be shown in Power Query.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Therefore, currently, you cannot do data transformation for datasets in Power Query.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
