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 ...
Thank you very much, i will follow this steps
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,