Forum Discussion
Custom Query in Power BI Service
Hello, I have a data set that is available at a web URL where the date is encoded in a Uri GET variable. I have the PowerQuery functioning perfectly on the desktop, but the "refresh" option isn't...
I think that the parameter query is likely the best way. I discovered that I can omit the "dateto" variable from the URL and it gives me exactly what I need.
Hi,
Thank you for the compliment on my dahsboard.
I am not sure that Power BI Gateway(on premises or personal) supports the change of the data source URL every day automatically and dynamically!
Maybe trying the 'Parameter' in Power Query can help you solve the problem,https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
Please let me know if this will work out for you!
I think that the parameter query is likely the best way. I discovered that I can omit the "dateto" variable from the URL and it gives me exactly what I need.