Sharing sync'd queries amongst reports

[tomascid]

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.

[BA_Pete · Accepted solution]

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

Pete

[Anonymous · Accepted solution]

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.

[BA_Pete · Accepted solution]

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

Pete