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

    Paarth Sanghavi on 05 Jun 2023 14:57:40

    RE: Direct Query for SharePoint List

    Organic next step. Need SPO Direct query integration in PowerBI to get value out of the PowerApps-PowerBI integration

    Vipul Shah's profile image Profile Picture

    Alexander Pohl on 10 Mar 2023 08:28:32

    RE: Direct Query for SharePoint List

    Still voting for this in 2023 !

    Vipul Shah's profile image Profile Picture

    Liviu-George Dragoiu on 30 Dec 2022 17:14:30

    RE: Direct Query for SharePoint List

    Much much needed

    Vipul Shah's profile image Profile Picture

    Bjarte Tysdal Abrahamsen on 28 Nov 2022 09:31:25

    RE: Direct Query for SharePoint List

    VOTING FOR THIS! Would be very helpful!

    Vipul Shah's profile image Profile Picture

    Carlo Ignacio on 09 Nov 2022 02:18:01

    RE: Direct Query for SharePoint List

    This would be very helpful for us, please consider this one.

    Vipul Shah's profile image Profile Picture

    Kenneth Bassett on 07 Nov 2022 15:50:16

    RE: Direct Query for SharePoint List

    This would be really useful for my organization since SharePoint is one of our primary platforms for data storage and sharing. Not only would this help with large file sizes, but integrating a Power App into a Power BI report for user entry purposes requires a direct query connection to the table storing the user entries. It would be extremely useful to be able to use a SharePoint list for that source!!!

    Vipul Shah's profile image Profile Picture

    William Johnson on 11 Oct 2022 14:02:51

    RE: Direct Query for SharePoint List

    Voted, would be super useful

    Vipul Shah's profile image Profile Picture

    Eric Klamm on 12 Apr 2022 20:40:56

    RE: Direct Query for SharePoint List

    The hourly(ish) OneDrive cloud refresh is not frequent enough and the 30 minute frequency on Premium Capacity can consume a lot resources if not used wisely. Having a direct query option to SP online would open up a significant amount of possibilities for real time business oversight using Power BI, especially for organizations that rely on SP as their primary data platform.

    Vipul Shah's profile image Profile Picture

    Ivan Berry on 23 Feb 2022 17:31:26

    RE: Direct Query for SharePoint List

    This opens up a lot of interactive possibilities for reports. It is very easy and cool to associate a powerapp with a record in a table, unfortunately there is a long refresh delay to see the changes in powerbi if that is populated into a sharepoint list.

    Vipul Shah's profile image Profile Picture

    Jonathan Sovsky on 10 Dec 2021 21:11:22

    RE: Direct Query for SharePoint List

    Crucial