Skip to main content

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.