web
You’re offline. This is a read only version of the page.
close
Skip to main content

    Power BI

    Needs Votes

    Direct Query for SharePoint List

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