Forum Discussion
Custom Query in Power BI Service
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,
Try to use DAX instead of M code in Power Query,
First of all, that is a very cool dashboard! I'm impressed.
With that said, here's my problem. The data source URL changes by day, so I need to find a way to query a web CSV that is available at a changing address. An example is this:
Today my CSV is available at www.website.com/handler.aspx?from=may1&to=may30
Tomorrow my CSV is available at www.website.com/handler.aspx?from=may1&to=may31
I can accomplish this by using some M to reference the date dynamically. I can't have the data source refresh automatically though. Any options? Would the personal version of the gateway help in this instance?
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.