Power BI
Needs VotesEnable DirectQuery for Excel Files in OneDrive/OneDrive for Business/Sharepoint
Vote
(5)
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.