Forum Discussion
Power BI Dynamic Data Refresh for Dynamic SharePoint URLs
I have managed to use a Power Automate flow to fetch files from the URL provided on excel and copy it over to a static location. From there Power BI would pick up and process. So, irrespective of dynamic entry in the source excel, Power BI would be able to fetch it
The paths are dynamic and is sourced from excel cells. FYR:
Hi Anonymous,
your SharePoint paths are coming from Excel cells, Power BI Service is not able to refresh it. In Desktop it works because it uses your local connection, but in the Service the URL must be fixed and known while publishing.
You can try using the SharePoint Folder connector and then filter the required files in Power Query. This way, it keeps one common connection, and the refresh will work fine in the service.If your paths keep changing, then you may need to handle that part outside Power BI, like by using Power Automate or a Dataflow to bring all files into one location before loading them in Power BI.
please go through with the below document hope it may resolve your Issue
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-data
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Community Support Team.
Hi Anonymous,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Community Support team.