Forum Discussion
Power query for bi service
Why can't Microsoft make Power query available for power bi service
5 Replies
Hi Mohamedatyea,
Do you mean in your Semantic Model? Because for example in Data flows you can use Power Query.
If that is the case I would suggest to upvote an existing idea to let Microsoft know you really need/want this feature:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=887f5c80-cfa9-44b5-b797-c1434fbd622e
Or register your own idea:
https://ideas.fabric.microsoft.com/
If you are talking about something else please add a bit more details about what you are missing specifically.
Thank you for your reply.
Yes I was talking about semantic model. After you published your report to the workspace, you can't modify the query any more, and you have to go back to the power bi desktop to make whatever modification you want to the data (using the power query) and then republish the report again. Am i right or there is something that I'm missing here?
Hi Mohamedatyea
Power Query editing is available in the cloud(Power BI Service - app.powrbi.com) mainly through Dataflows, while Power BI Desktop remains the primary tool for data level transformations.
Please check out Microsoft Documentation: https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create
Yes, you are right for a semantic model (dataset) built in Power BI Desktop, cannot edit the Power Query transformations in Power BI Service.
what fo you exactly want to do?
Hello Mohamedatyea,
Power Query is available in Power BI Service via Dataflows Gen2, Datamarts, or semantic model editing (Preview), while full query editing is still done in Power BI Desktop.
