Power BI

Needs Votes

Direct Query for SharePoint List

Vote (717)

Vipul Shah on 26 Sep 2016 10:41:41

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.

Comments (56)

Comments (56)

Victor Iturbides on 06 Oct 2021 14:37:19

RE: Direct Query for SharePoint List

Lets do this please

Ed Zielonka on 09 Sep 2021 16:11:17

RE: Direct Query for SharePoint List

Voting for this too!

Gary Shaw on 23 Jun 2021 20:41:30

RE: Direct Query for SharePoint List

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

Kean Gunton on 01 Jun 2021 15:51:43

RE: Direct Query for SharePoint List

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

Kunaal Bhagani on 24 May 2021 10:54:18

RE: Direct Query for SharePoint List

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

Alan Rowberry on 29 Mar 2021 23:39:10

RE: Direct Query for SharePoint List

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!