Theo_S_Kontos's avatar
Theo_S_Kontos
New Member
3 years ago
Status:
New

Query a Power BI Dataset into a PBI Datamart using the native Power Query interface

Our team needs the ability to query a Power BI Dataset that is published in the service, into a Datamart, so we could take weekly snapshots without using Excel, Power Automate, or another solution. This helps us bring the data straight in and is much easier to maintain than Power Automate solutions. Right now Power Query in Dataflows/Datamarts does not allow querying Power BI Datasets, which seems a bit counterintuitive.

Recent ideas