Forum Discussion
Power Query in Power BI Service
I am developing a dashboard in Power Bi Service and I don't know if I can use Power Query to transform or edit data from a Google Sheets table, which is updated every day, so I want the dashboard to update with this data,
Previously I was developing the same panel but in power bi desktop (with the same Google sheets table), but I got bored of uploading every change I made to have the same progress in power bi service, so I copy and paste this panel in the power bi service so you don't have to do this,
My question is can I use Power Query in the Power Bi service in case I have to change or transform a specific value in the semantic model,
Thanks
2 Replies
Hi. Well. You could, but you will always need PowerBi Desktop for just powerbi developments. Only with Fabric you could work end to end in the Service.
In order to use power query online you can create Dataflows. That content is for creating entities/tables with Power Query. Then you should create the semantic model with Power Bi Desktop connecting to the dataflow. Build the data model, relationships and measures. Once it's ready, publish the semantic model. That way you can change power query online and reporting data visuals from service.
I hope that helps,
