Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Strange Error with refresh

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 errorthe 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"

 

Status: Needs Info

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

 

Comments
v-yetao1-msft
Community Support
Status changed to: Needs Info

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