Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Direct Query for SharePoint List

    Vote (693) 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 (55)
    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.

    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?