Forum Discussion

Franklin1's avatar
Franklin1
Advocate 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
Memorable 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
    Advocate 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!