Skip to main content

    Power BI

    Needs Votes

    Direct Query for SharePoint List

    Vote (309) 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 (28)
    Vipul Shah's profile image Profile Picture

    99995b67 c126-4999-8bef-b977ba4652ac on 05 Jul 2020 23:57:08

    RE: Direct Query for SharePoint List

    this would be a very good add

    Vipul Shah's profile image Profile Picture

    7a70e0bf 4d7c-4c99-abc0-fd3f7f67c408 on 05 Jul 2020 23:57:02

    RE: Direct Query for SharePoint List

    Please, provide DirectQuery functionality for SharePoint Online Lists.

    Vipul Shah's profile image Profile Picture

    64cf6766 c8c5-4a59-bfea-aa5c9dfaf939 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

    2948cd42 ead9-4451-a671-aa7e0bf7209e 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

    b140b21f 7745-45a9-9cdc-2d599245dd63 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    0e31ce9a ceb4-4e66-81f9-9796da4b2823 on 05 Jul 2020 23:46:14

    RE: Direct Query for SharePoint List

    Yes please!!!

    Vipul Shah's profile image Profile Picture

    dbd9b92d 8010-4a1d-af1e-1610685e655c 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

    a3309361 99be-ea11-a812-000d3a8ddfb2 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

    07b11388 a556-42b8-8cf3-8e25eb468b3b on 05 Jul 2020 23:37:31

    RE: Direct Query for SharePoint List

    Please, provide DirectQuery functionality for SharePoint Online Lists.