Forum Discussion

tomascid's avatar
tomascid
Frequent Visitor
4 years ago
Solved

Sharing sync'd queries amongst reports

I'm looking for a solution conceptually similar to this:

https://blog.crossjoin.co.uk/2016/11/29/sharing-power-query-queries-with-azure-data-catalog/

However it seems that Microsoft has discontinued the Data Catalog. 

Does anyone know how to keep a query sync'd amongst multiple reports? Ideally I'd like a library of "final" queries which I can import, export, check in/out of a shared library with versioning, etc.

  • Hi tomascid ,

     

    Sounds like you want Dataflows.

    In the Service, select a workspace you want to add a dataflow to, then go to the 'New' button and select Dataflow:

     

    You'll get a load of options for sources, but these are essentially the same as 'Get Data' sources in Desktop. Once you're in, just think of your Dataflows as 'Power Query Online'.

     

    You can access your dataflows from Desktop by going to New Source > Power Platform > PBI Dataflows:

     

    More MS info:

    https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service 

     

    Pete

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi tomascid ,

     

    There are three common ways to share queries:

    1.Copy / Paste
    2.Copy the M code

    3.Creating a Power BI Template (.pbit) to share with other users.

     

    Reference: Share a query - Power Query | Microsoft Docs

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Hi tomascid ,

     

    Sounds like you want Dataflows.

    In the Service, select a workspace you want to add a dataflow to, then go to the 'New' button and select Dataflow:

     

    You'll get a load of options for sources, but these are essentially the same as 'Get Data' sources in Desktop. Once you're in, just think of your Dataflows as 'Power Query Online'.

     

    You can access your dataflows from Desktop by going to New Source > Power Platform > PBI Dataflows:

     

    More MS info:

    https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service 

     

    Pete

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi tomascid ,

     

    There are three common ways to share queries:

    1.Copy / Paste
    2.Copy the M code

    3.Creating a Power BI Template (.pbit) to share with other users.

     

    Reference: Share a query - Power Query | Microsoft Docs

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.