Skip to main content
Microsoft Idea

    Power BI

    New

    BUG: Data Marts - Power Query does not work when connected to an enterprise gateway

    Vote (1) Share
    Andrew Tuplin's profile image

    Andrew Tuplin on 18 Oct 2022 20:32:13

    I have a data mart connected to a SQL Server via an enterprise gateway. The data mart is able to retrieve data from the gateway (it can be refreshed without issue) but Power Query isn't able to connect to the source, so no Power Query activities can be accomplished (e.g. renaming a data set, filtering a data set, even manually adding rows to a blank data set).