Power BI

Needs Votes

Direct Query for SharePoint List

Vote (691)

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)

Comments (58)

Power BI User on 05 Jul 2020 23:57:08

RE: Direct Query for SharePoint List

this would be a very good add

Jaime Derks on 05 Jul 2020 23:57:02

RE: Direct Query for SharePoint List

Please, provide DirectQuery functionality for SharePoint Online Lists.

Ankush on 05 Jul 2020 23:55:26

RE: Direct Query for SharePoint List

Any updates on this functionality?

Tania Wallace on 05 Jul 2020 23:48:18

RE: Direct Query for SharePoint List

Also for on premise Report Server using Sharepoint Online list as source.

Kory on 05 Jul 2020 23:47:11

RE: Direct Query for SharePoint List

Yes... Especially if we are looking to incorporate Power App within our Dashboards. We want to see changes reflected as soon as possible - instead of waiting for a scheduled refresh.

Power BI Ideas Admin on 05 Jul 2020 23:46:16

RE: Direct Query for SharePoint List

I totally agree with Nick as for the PowerApps / PowerBI integration with direct refresh.

Rob F on 05 Jul 2020 23:46:14

RE: Direct Query for SharePoint List

Yes please!!!

Andreas S. on 05 Jul 2020 23:44:24

RE: Direct Query for SharePoint List

Should hopefully be not too complicate, or?

Power BI Ideas Admin on 05 Jul 2020 23:38:01

RE: Direct Query for SharePoint List

Would greatly help the PowerApps and Power BI integration. Submit data via PowerApp to Sharepoint List, view data in Power BI without needing a full data refresh.

Evgeniy Ivanov on 05 Jul 2020 23:37:31

RE: Direct Query for SharePoint List

Please, provide DirectQuery functionality for SharePoint Online Lists.