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.
I'm using a Web.Contents call in a source query and while it works on the desktop client, when attempting to set the dataset for scheduled refresh, the "data source can't be refreshed because the credentials are invalid".
I cannot follow the suggestion to use the "Skip Test Connection" made here (https://blog.crossjoin.co.uk/2019/04/25/skip-test-connection-power-bi-refresh-failures/) because that option does not appear.
I also cannot circumvent what appears to be the static analysis check on the Web.Contents call as suggested here (https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...) because no part of the URL can be resolved successfully.
The exact line I am attempting to use looks like this:
Source = Json.Document(Web.Contents("https://api.appcenter.ms/v0.1/apps/", [Query=[start=DateTime.ToText(Date.AddMonths(DateTime.LocalNow(), -1), "yyyy-MM-dd"), errorType="UnhandledError"], Headers=[#"X-API-Token"="XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"], RelativePath="[AppOwner]/[AppName]/errors/errorCountsPerDay"]))
An example of the call without the dynamic date placement would look like this:
Without the ability to skip connection validation, I have to republish every day to get up-to-date data. Is there another workaround for this that I am unaware of? Is there a reason I do not see the "Skip Test Connection" option?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.