Forum Discussion
Power BI Dynamic Data Refresh for Dynamic SharePoint URLs
I have an excel file with multiple sharepoints paths captured for different excel files. I want to create a power bi report which looks into this excel file and fetch listed excel files via the share...
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
Anonymous Power BI Service requires the URL to be fully evaluable at design time for scheduled refresh to work.