Forum Discussion

Franklin1's avatar
Franklin1
Icon for Advocate I rankAdvocate I
8 years ago

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...
Need Help
tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
8 years ago

Hi Franklin1,

 

So far it's a limitation of PBI for passing parameters in the input of query. You could do workaround by get a list of file in folder by its static link and return list of binary contents. So you could pass the binary content as the input. 

 

 

 

If this works for you please accept it as solution and also like to give KUDOS.

Best regards
Tri Nguyen

Franklin1's avatar
Franklin1
Icon for Advocate I rankAdvocate I
8 years ago

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!