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,
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.