Skip to main content
Microsoft Idea

    Power BI

    New

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

    Vote (2) Share
    Theo Kontos's profile image

    Theo Kontos on 21 Mar 2023 17:48:55

    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.