Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Enable DirectQuery for Excel Files in OneDrive/OneDrive for Business/Sharepoint

    Vote (5) Share
    's profile image

    on 06 Aug 2019 00:47:38

    Currently DirectQuery is not available for any of these data sources. These are all online data sources hosted by Microsoft. It would be extremely helpful if DirectQuery were available for them!

    I am attempting to use the new PowerApps PowerBI refresh integration. However, this only works for data sources in DirectQuery mode. If I am trying to connect to an Excel file in OneDrive for Business I have to manually refresh my report every time the source file is updated from PowerApps.