How to transform data from Power BI service?

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.