Skip to main content
Microsoft Idea

Power BI

Needs Votes

Direct Query for SharePoint List

Vote (691) Share
Vipul Shah's profile image

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 (58)
Vipul Shah's profile image Profile Picture

G Jones on 22 Oct 2021 09:56:03

RE: Direct Query for SharePoint List

Voted.

Vipul Shah's profile image Profile Picture

Shama Firdos on 07 Oct 2021 12:13:42

RE: Direct Query for SharePoint List

Much needed. voted

Vipul Shah's profile image Profile Picture

Victor Iturbides on 06 Oct 2021 14:37:19

RE: Direct Query for SharePoint List

Lets do this please

Vipul Shah's profile image Profile Picture

Ed Zielonka on 09 Sep 2021 16:11:17

RE: Direct Query for SharePoint List

Voting for this too!

Vipul Shah's profile image Profile Picture

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

Vipul Shah's profile image Profile Picture

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.

Vipul Shah's profile image Profile Picture

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!

Vipul Shah's profile image Profile Picture

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!

Vipul Shah's profile image Profile Picture

Deepakbhai Desai Chintan on 22 Jan 2021 06:21:00

RE: Direct Query for SharePoint List

Please implement this. SharePoint is very know data source these days...

Vipul Shah's profile image Profile Picture

Nick Dorak on 24 Sep 2020 12:57:28

RE: Direct Query for SharePoint List

Needed for item level security.