Forum Discussion
Connecting to a SharePoint folder and creating visuals from multiple documents
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
5 Replies
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
Super User
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?- 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-msftMicrosoft Employee
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
- 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
