Combine files from a Sharepoint folder in POWER BI SERVICE

[Elina_Mirin]

Hi! I want to create a Data Flow in Power BI Service and I want to make a connection to Sharepoint. When I try to Combine the files from a folder from Sharepoint, I get an error. In Power BI Desktop when I combine the files from Sharepoint, the Transform Files are automatically created, but this is not happening in Power BI Service.

I am using SharePoint.Contents to get the files from Sharepoint.

Does anybody know how to create a Data Flow, connect to Sharepoint and combine the files in Power BI Service?

[Elina_Mirin]

@v-tangjie-msft Thank you! It worked with SharePoint.Folder.

[v-tangjie-msft · Accepted solution]

Hi @Elina_Mirin ,

Power BI Service doesn't seem to support merging files, merge files in Desktop and create a dataflow.

Please refer to the following documents for more information.

Combining Excel Files hosted on a SharePoint folder with Power BI | Microsoft Power BI Blog | Micros...

Use Power BI dataflows to warehouse SharePoint list data – The White Pages (tygraph.com)

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.