Skip to main content

    Power BI

    Needs Votes

    Allow Direct Query connections from Power Query in Excel to Power BI dataset

    Vote (6) Share
    Blake Slattery's profile image

    Blake Slattery on 23 Dec 2020 12:41:34

    Hello,

    Using Power Query's "Get Data" in Excel allows you to create a "Live Connect" connection to a Power BI Dataset, which then opens in a Power Pivot table.

    The option to use Power BI and create a Direct Query connection from Power BI to a Power BI dataset in Service was recently released. Would be great to get this capability added to Excel's PowerQuery