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

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.

Errir 400: API Credentials power BI online problem

Hi.

Im trying to get data from OKTA into Power BI using an API token. 

In the PowerBI desktop version it works fine, but ones I publish I get an error in the data sets settings:

Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at https://ambea-admin.okta-emea.com/api/v1/apps.)Hide details
Activity ID:XXXXXXXX-XXXX-XXXX-XXXX-XXXXXX
Request ID:XXXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXX
Status code:400
Time:
Version:13.0.4385.126
Cluster URI:https://wabi-north-europe-redirect.analysis.windows.net


Im using Anonymous Authentication (because I have the token), I have tried with Basic and Windows also but neither works.

 

As I said the script works fine desktop:

 

let  
actualUrl = "https://removed.okta.com/api/v1/apps",  
options = [Headers =[#"Authorization"="SSWS "Removed""]],
result = Web.Contents(actualUrl, options),

 

in

result



Anyone know a solution?

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @VictorLysell,

 

Would you please send the URL to me via private message? 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
luchitogiuse
Frequent Visitor

HI, i have the same issue, 

 

In desktop works fine, i'm using anonymous cause i have token , and using gateway.