Forum Discussion
Franklin1
8 years agoAdvocate I
Scheduled Refresh is not working with function
Hello everyone, Need your help desperately... I created a report in PBI Desktop. The data is from Excel file, which is basically 2 columns - Month and URL. I have created a function (see be...
Franklin1
8 years agoAdvocate I
Thanks a lot.
I think your solution is valid when we have a number of excel files located in a folder.
The issue is that the my data is not coming from few excel files located in a folder, but it is coming from a web with a dynamic web address.
On a monthly basis, i update the excel file with the web address for the current month.
So taking the list of files in folder is not working.
Do you have any other ideas?
Thanks a lot!
v-jiascu-msft
8 years agoMicrosoft Employee