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
v-hjannapu : I see you have provided a similar solution in the past. Can you please assist?
Hi Anonymous,
Thank you for posting your query in Microsoft Fabric Community Forum. Also Thank you MasonMA,
GeraldGEmerick , for those inputs on this thread.
your SharePoint paths are coming from Excel cells, that’s why the refresh is failing after publishing.
In Power BI Desktop it works fine because it uses your local access, but in Power BI Service, the URLs need to be fixed and known while creating the report. Dynamic paths coming from Excel can’t be read by the service during refresh.
You can try using the SharePoint Folder connector and then filter the files you need inside Power Query. This keeps one fixed connection and usually works fine after publishing.
please go through with the below document hope it may resolve your Issue
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive
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.