Power BI Rest API via Web query

[9418]

Hi All

Microsoft Power BI embedded Rest API is working, I can get workspace info (Groups - Get Groups - REST API (Power BI Power BI REST APIs) | Microsoft Learn), but I try to use Power BI Web to creat connection to retrieve data into Power BI with Authorization Header , not working, the commnet is ---Details: "The 'Authorization' header is only supported when connecting anonymously. These headers can be used with all authentication types: Accept, Accept-Charset, Accept-Encoding, Accept-Language, Cache-Control, Content-Type, If-Modified-Since, Prefer, Range, Referer" Who can tell me what reason behind it?

[Anonymous · Accepted solution]

Hi @9418 ,

After test, the error you were seeing is from API you were trying to connect to. Your datasource may stop trying to login "Anonymous" and had got set to "Basic". 
Please follow the steps:
File>Options and settings>Data source settings
Then edit the permission to reset the type. The credential type should look like as below.

I also found some posts with the same problem you are facing that might be helpful:
Solved: The 'Authorization' header is only supported when ... - Microsoft Fabric Community
Solved: How to pull data from Web API into PowerBI using A... - Microsoft Fabric Community
Solved: Remote API Access to data source sudden errors - Microsoft Fabric Community
Solved: Authorization Header unsupported but using Anonymo... - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[9418]

 Why they mentioned token comma expected, totally confused as I copies the temp token from Microsoft webpage