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,
Try to use DAX instead of M code in Power Query,
Last updated at = UTCNOW()
Check out my report, the data source is a URL and I added a visual of the UTC time using DAX. Bottom right of the Home page:
The refresh is through a personal Gateway 8 times a day and works just fine.
Hope you like it.