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

Ankush on 05 Jul 2020 23:55:26

RE: Direct Query for SharePoint List

Any updates on this functionality?

Vipul Shah's profile image Profile Picture

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.

Vipul Shah's profile image Profile Picture

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.

Vipul Shah's profile image Profile Picture

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.

Vipul Shah's profile image Profile Picture

Rob F on 05 Jul 2020 23:46:14

RE: Direct Query for SharePoint List

Yes please!!!

Vipul Shah's profile image Profile Picture

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

RE: Direct Query for SharePoint List

Should hopefully be not too complicate, or?

Vipul Shah's profile image Profile Picture

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.

Vipul Shah's profile image Profile Picture

Evgeniy Ivanov on 05 Jul 2020 23:37:31

RE: Direct Query for SharePoint List

Please, provide DirectQuery functionality for SharePoint Online Lists.

Vipul Shah's profile image Profile Picture

Evgeniy Ivanov on 05 Jul 2020 23:37:24

RE: Direct Query for SharePoint List

Please, provide DirectQuery capability for SharePointOnline lists.

Vipul Shah's profile image Profile Picture

Kawabata Yoshihiro on 05 Jul 2020 23:19:33

RE: Direct Query for SharePoint List

Yes, I want it too.
For easy / quick / real-time, I want the DirectQuery to SharePoint List, instead of Import from SharePoint List.