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