Skip to main content
Microsoft Idea

    Power BI

    Under Review

    SharePoint folders connector for Dataflows

    Vote (66) Share
    CK's profile image

    CK on 14 Nov 2018 00:49:28

    Please create a SharePoint folders connector for Dataflows

    Comments (8)
    CK's profile image Profile Picture

    Sarah Griffin on 06 Jul 2020 00:17:24

    RE: SharePoint folders connector for Dataflows

    We need the ability to combine multiple files (with transform sample file) into a query. As mentioned below, there is still a multiple Binaries issue when trying to do this.

    CK's profile image Profile Picture

    Sarah Griffin on 06 Jul 2020 00:14:32

    RE: SharePoint folders connector for Dataflows

    Glad the connector is there, but there is still the Binaries issue when trying to Combine Files within the SharePoint Folder - please address this.

    CK's profile image Profile Picture

    Martin K on 06 Jul 2020 00:02:22

    RE: SharePoint folders connector for Dataflows

    This is now available: https://powerbi.microsoft.com/en-us/blog/50-new-features-in-dataflows-this-month/

    CK's profile image Profile Picture

    Darrin Wolter on 05 Jul 2020 23:55:55

    RE: SharePoint folders connector for Dataflows

    And do it for OneDrive as well

    CK's profile image Profile Picture

    Mike Honey on 05 Jul 2020 23:53:10

    RE: SharePoint folders connector for Dataflows

    I can copy in a query from Power BI Desktop, but typically the whole point is to use the Combine Binaries functionality that generates parameters and a generated function - that doesnt seem to be supported in Dataflows.

    CK's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:51:08

    RE: SharePoint folders connector for Dataflows

    I confirm that it works when you do copy/paste from pquery to blank but you need to do it step by step.

    CK's profile image Profile Picture

    Darek on 05 Jul 2020 23:40:12

    RE: SharePoint folders connector for Dataflows

    Try copy/paste your M-code from PBI desktop into empty query.
    https://docs.microsoft.com/en-us/power-bi/service-dataflows-data-sources#connecting-to-additional-data-sources

    CK's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:39:42

    RE: SharePoint folders connector for Dataflows

    definitely needed