Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I use the following POST method to get my data as JSON:
let url = "https://api.adtraction.com/v1/affiliate/transactions/combined", body = "{""fromDate"": ""2018-01-01T03:37:01.621Z"", ""toDate"": ""2018-08-01T03:37:01.621Z""}", Parsed_JSON = Json.Document(body), BuildQueryString = Uri.BuildQueryString(Parsed_JSON), Source = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json", #"X-Token"="XXX"], Content = Text.ToBinary(body) ] )) in Source
Everything works perfectly in PowerBI Desktop. I can manually refresh data at any time.
However, when published in PowerBI Service, it says that credentials are invalid. This source does not require credentials, it used API Token. More specifically, the error looks like this:
Any suggestions what's happening here?
Solved! Go to Solution.
Hi Donatas,
In your senario, you can refer to this blog to achieve a workaround: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power....
Regards,
Jimmy Tao
Hi Donatas,
In your senario, you can refer to this blog to achieve a workaround: https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power....
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.