Direct Query for SharePoint List

[vishah]

With large volume of data in SharePoint List, it takes forever for a scheduled/on-demand refresh as it refreshes everything from scratch. It would be nice to support direct query (live query) against SPO List. Customer is expecting to see real-time dashboard change when item is updated in SPO list.

[EK103]

The hourly(ish) OneDrive cloud refresh is not frequent enough and the 30 minute frequency on Premium Capacity can consume a lot resources if not used wisely. Having a direct query option to SP online would open up a significant amount of possibilities for real time business oversight using Power BI, especially for organizations that rely on SP as their primary data platform.

[johnsonwc1]

Voted, would be super useful

[kbassett]

This would be really useful for my organization since SharePoint is one of our primary platforms for data storage and sharing. Not only would this help with large file sizes, but integrating a Power App into a Power BI report for user entry purposes requires a direct query connection to the table storing the user entries. It would be extremely useful to be able to use a SharePoint list for that source!!!

[carlo_ignacio]

This would be very helpful for us, please consider this one.

[bjarte_abrahams]

VOTING FOR THIS! Would be very helpful!

[liviu_dragoiu]

Much much needed

[PohlA10]

Still voting for this in 2023 !

[paarth_sanghavi]

Organic next step. Need SPO Direct query integration in PowerBI to get value out of the PowerApps-PowerBI integration

[Neel_Doshi]

This will definitely add value to PBI - SP integration, hope it will be taken up soon!

[Ramanjineyulu_r]

Much needed requirement, kindly facilitate on top priority.