I'm getting a strange error when i try to refresh my dataset in PowerBI Premium that consumes an API. I have deactivated the test connection and the authentication is set anonymous and public. The refresh of the exact same .pbix archive works well in my other free account. Does anyone knows what could be causing this?
the mentioned error
here is the query i'm doing:
let
response = Json.Document(Web.Contents(
"http://myservice/api",
[
RelativePath="/path1/path2?",
Query=[Id="xxxx"],
Headers=[#"API-Auth"="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx",
#"accept"="application/json"]
]
) ),
Data = response[Dados],
#"new column" = Table.FromList(Data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
in
#"new column"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Andre_gil
You mentioned that "The refresh of the exact same .pbix archive works well in my other free account." , rre you refreshing with the same API inside My workspace? What is the data source you are using to test?
Best Regards,
Community Support Team _ Ailsa Tao