Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |