Forum Discussion
HELP NEEDED: GETING DATA FROM API
I have to pull a data from a websource that provides a webAPI to downlood the data, here's a tamplate: https://hq.appsflyer.com/export/com.greatapp/partners_report/v5?api_token=xxxx &from=2018-0...
ImkeF , Can you help with this.
badluckmath , Anonymous , while imkef has a look at it. Refer if this can help, the "faking out" portion of the link -http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
While this link might not be of great help...
Hi all,
as you're doing this in the query editor, you have to use the M-language (Power Query) and not DAX.
This is how to retrieve todays date formatted as text in the desired format:
Date.ToText ( Date.From ( DateTime.LocalNow() ) , "yyyy-MM-dd" )
If you want to refresh these queries in the Power BI service, you have to make further adjustments like mentioned in the article that amitchandak has posted.