Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
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,
Happy to help!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 56 | |
| 55 | |
| 32 | |
| 18 | |
| 14 |