Power Query in Power BI Online

[S0PHIE]

Hi All,

Is there any way to use Power Query in Power BI online? I have a trial access to Microsoft Fiber.

I'm trying to update my Power BI online dashboard as the connection to the excell spreadsheet (the source data) is broken due to some changes. I successfully rectified the issue in Power BI app by usnig Power Query, but can't do the same online.

Thank you. 

[pallavi_r · Accepted solution]

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

[v-ssriganesh]

Hi @S0PHIE,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @S0PHIE,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[SaiTejaTalasila]

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 

[v-ssriganesh · Accepted solution]

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 Learn

If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
Thank you.

[v-ssriganesh]

Hi @S0PHIE 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[anmolmalviya05]

Hi , I hope you are doing good!

Directly using power query for your existing report in power bi service just like power bi desktop is not supported, but in Microsoft Fabric they have introduced Dataflow Gen 2 which works and have similar interface as Power Query editor. 
You can checout Microsoft documentation for the same: https://learn.microsoft.com/en-us/fabric/data-factory/create-first-dataflow-gen2

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Let's Connect on LinkedIn: https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

Subscribe my youtube channel for Microsoft Fabric and Power BI updates: https://www.youtube.com/@AnmolPowerBICorner

@S0PHIE

[pallavi_r · Accepted solution]

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