Hi there, I'm facing the following issue. The following script refreshes my dashboard in PBI Desktop (and even in PBI Service), but it gives me a credential error and says that it can't retrieve the latest data:
It says: "Failed to update data source credentials: The credentials provided for the Web source are invalid."
It doesn't matter which privacy level I select, it keeps telling me that it is invalid. I spent quite some hours to fix this and search for a solution but I keep hitting a wall.
I don't have an account or something else, just an API key which is enough to retrieve the data. This is my script (anonymous of course):
let
// retrieving the token:
url = "https://company.firmname.com/auth/login/firmnamepowerbi/apiKey?apiKey=7890abcd",
body = "{ ""client_id"": ""****"", ""client_secret"": ""****"", ""grant_type"": ""****"", ""audience"":""****""}",
tokenSubStep = Json.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body) ] )),
tokenResponse = tokenSubStep [token],
// add token in the URL:
Source = Json.Document(Web.Contents("https://company.firmname.com/list/projects", [Headers=[Authorization="Bearer "&tokenResponse]])),
items = Source[items],
#"Converted to Table" = Table.FromList(items, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
I don't know if the body part is needed, but I found above template online, and even when I just filled it likes this (****) it worked in PBI desktop. Tried removing that line, but then it did not work.
Just for clarity, the only thing that I have/need it he API key: 7890abcd. When I enter the url (2nd line) in Postman, it also gives me results, but it is just the credential part that gives me issues. Normally with API's I also get an account and password etc, but now I just have an API key so I don't know how to adjust my script.
I hope someone can help me out! Thanks in advance!
