Forum Discussion
Some credentials arent validated problem
Hi guys,
I'm having this problem below. The thing is that all those APIs has almost the same setup. I can't get powerbi to test those conections again. Setting thos ein PowerBI web doesnt work.
Any ideas?
7 Replies
Hi, efilipe
I wonder whether you are using AAD OAuth. The Azure Active Directory (AAD) OAuth token, used by many different data sources, expires in approximately one hour. You can run into situations where loading data takes longer than the token expiration (more than one hour), since the Power BI service waits for up to two hours when loading data. In that situation, the data loading process can fail with a credentials error. If you have a Web connector script that's using the Web.Page function, and you have updated your dataset or report after November 18th, 2016, you must use a gateway for refresh to work properly.
For further information, please refer to the official document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
This is how I call the API:
let
Source = Json.Document(Web.Contents("https://[URL o the site]/api-public/report/query/50", [Headers=[#"X-API-Key"="1234567890"]]), 65001),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"I'm calling all the API in the same way, but a few I skipped the "Test" and now I have this error that I can't fix, it seems.
When I try to update the credention of those with a problem, I get:
Failed to update data source credentials: Web.Contents failed to get contents from 'https://[SITE URL]/api-public/report/query/58' (400): Hide details
