Skip to main content

Power BI

Needs Votes

Direct Query for SharePoint List

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

Ralph Myers on 05 Jul 2020 23:04:47

RE: Direct Query for SharePoint List

Any update on this?

Vipul Shah's profile image Profile Picture

Power BI User on 05 Jul 2020 22:51:08

RE: Direct Query for SharePoint List

'+1

Vipul Shah's profile image Profile Picture

Scott A on 05 Jul 2020 22:48:56

RE: Direct Query for SharePoint List

'+1

Considering that PBI and SPO are both cloud apps hosted by MS, why hasn't this happened yet?

Vipul Shah's profile image Profile Picture

Stefan Sainiuc on 05 Jul 2020 22:47:32

RE: Direct Query for SharePoint List

How about DirectQuery for SharePoint Online List please?

Vipul Shah's profile image Profile Picture

Nikhil on 05 Jul 2020 22:45:40

RE: Direct Query for SharePoint List

'+1

Clients increasingly demanding real time data to be fetched.

Has there been any update on the this in the last year. Keen to know if Microsoft is working on this request.

Vipul Shah's profile image Profile Picture

Ian on 05 Jul 2020 22:30:48

RE: Direct Query for SharePoint List

Exactly this. There is a huge market using SharePoint today and connecting visuals to SPO Lists with as close to real-time data as possible will open up a world of use cases. One in particular, a client is looking to see a prioritization matrix change with respect to new data entered in a List to make key business decisions. Having live connectivity to this list is not something Tableau or Qlikview can do today and would stand a significant opportunity for Microsoft.