Connecting to a SharePoint folder and creating visuals from multiple documents

[Anonymous]

Hi, I am trying to create a Power BI report which is connected to multiple excel doucments in a SharePoint folder. I have been able to connect to the SharePoint folder but so far have only successfully been able to work with data from one document. I want to do this so I can then create a report which will display visuals from each document on a seperate report page. All the documents in the folder have the same layout and tables as they are created from a template. All the visuals for each document will also be the same.

Is this possible? And if so how can I go about achieving it?

Thank you

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[Anonymous]

Hi, I am trying to create a Power BI report which is connected to multiple excel doucments in a SharePoint folder. I have been able to connect to the SharePoint folder but so far have only successfully been able to work with data from one document. I want to do this so I can then create a report which will display visuals from each document on a seperate report page. All the documents in the folder have the same layout and tables as they are created from a template. All the visuals for each document will also be the same.

Is this possible? And if so how can I go about achieving it?

Thank you

[GilbertQ]

Hi there

You can do this by selecting from a SharePoint folder. It should then ask you if you would like to combine and edit.

If you select that it will then combine all the files into one table?

[Anonymous]

Hi, thank you for your reply. When I press combine and edit it only allows me to combine one table from each file. But I have around 12 tables in each folder. Is there a way to combine them all at once? Or is there a way I can just have all tables from each of the different source files without combining them?

[v-danhe-msft]

Hi @Anonymous,

Based on my research, you could achieve this feature by using the  SharePoint folder connector.

Reference:https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

Regards,

Daniel He