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.

[alan_rowberry]

Built a PowerApp to allow users to enter report annotations into a Sharepoint list - fantastic combination of tools that will really help my client. However, unless we can direct query Sharepoint users must wait until a refresh to be able to see their comments - this is inefficient and makes the feature quite weak. Please implement it!

[kbhagani1]

5 years and no update. Not looking like this will ever happen!

[Kean_Gunton]

Any way to get this idea promoted? Surely having 'live' data updates from a SP list would be a really useful reporting dashboard etc.

[fbcideas_migusr]

As SharePoint is our global platform, allowing direct query would open up a lot of possibilities for us

[ed_zielonka]

Voting for this too!

[VIturbides1]

Lets do this please

[fbcideas_migusr]

Much needed. voted

[glyn_jones1]

Voted.

[jonathan_sovsky]

Crucial

[ibdx]

This opens up a lot of interactive possibilities for reports. It is very easy and cool to associate a powerapp with a record in a table, unfortunately there is a long refresh delay to see the changes in powerbi if that is populated into a sharepoint list.