Forum Discussion
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:
Pete
- Anonymous4 years ago
Hi tomascid ,
There are three common ways to share queries:
1.Copy / Paste
2.Copy the M code3.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
- BA_PeteSuper User
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:
Pete
- AnonymousNot applicable
Hi tomascid ,
There are three common ways to share queries:
1.Copy / Paste
2.Copy the M code3.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.