Skip to main content

    Power BI

    Under Review

    SharePoint folders connector for Dataflows

    Vote (59) 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

    8aa64134 aab2-476b-9618-a178d048e189 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

    8aa64134 aab2-476b-9618-a178d048e189 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

    c21bef34 0d48-42e1-831e-a9797dace70b 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

    49eb64b8 dcfe-4276-ad59-fc14ce89b728 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

    af0019aa 9a7e-4776-9021-7b1171cd13bc 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

    a474b6f6 a706-45df-896e-3e7e46f004e9 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

    e1e441b2 c1ff-4cd8-877c-fe0e41919ab0 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

    b8cc46ef 562f-42d7-9697-ea5d3d5a9ec5 on 05 Jul 2020 23:39:42

    RE: SharePoint folders connector for Dataflows

    definitely needed