Forum Discussion
Power Query in Power BI Online
- 1 year ago
Hi S0PHIE ,
The earlier power query which you were using your PBI desktop has now moved to Fabric Dataflow Gen 2. MS Fabric Dataflow gen 2 can load multiple data sources and utilizes power query to do the required transformation.
Please refer - https://learn.microsoft.com/en-us/fabric/data-factory/create-first-dataflow-gen2
If this post helps, please accept this as a solution. Appreciate your kudos.
Thanks,
Pallavi
- 1 year ago
Hi S0PHIE,
Thanks for posting your query in Microsoft fabric community forum.
You can use Datamart in Microsoft Fabric to manage your Excel data connection and transformations directly in Power BI Online without relying on Power BI Desktop.DataMart enables you to utilize Power Query Online for data cleaning and transformation in the cloud. It stores data in an automatically generated SQL database, facilitating easy querying. You can schedule automatic refreshes to keep reports current and directly connect Power BI reports to DataMart for seamless integration. For further details, please refer to the official Microsoft documentation at the link below:
Introduction to datamarts - Power BI | Microsoft LearnIf this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.
Hi S0PHIE ,
Using Power Query in Power BI Online
Power BI online (service) doesn’t directly offer a Power Query editor like the Power BI Desktop application. However, you can leverage Power BI Dataflows to replicate and manage your queries online.
Open your Power BI Desktop file, go to Transform Data > Power Query Editor, select the table, and copy the M-query from Advanced Editor.
In Power BI online, go to your workspace, select New > Dataflow > Add New Tables > Blank Query, paste the M-query, and save the Dataflow.
Replace the old connection in Power BI Desktop with the Dataflow by connecting to Power BI Dataflows as the new data source.
Publish the updated report to Power BI online, ensuring it connects to the Dataflow for data updates.
I hope it will be helpful.
Thanks,
Sai Teja