Forum Discussion

S0PHIE's avatar
S0PHIE
New Member
1 year ago
Solved

Power Query in Power BI Online

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 spreadshe...
  • v-ssriganesh's avatar
    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 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.