Power BI Rest API via Web query

Question

Hi All&nbsp;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 Answer

Hi&nbsp;9418&nbsp;,After test, the error you were seeing is from API&nbsp;you were trying to connect to. Your datasource may stop trying to login "Anonymous" and had got set to "Basic".&nbsp;Please follow the steps:File&gt;Options and settings&gt;Data source settingsThen 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 CommunitySolved: How to pull data from Web API into PowerBI using A... - Microsoft Fabric CommunitySolved: Remote API Access to data source sudden errors - Microsoft Fabric CommunitySolved: Authorization Header unsupported but using Anonymo... - Microsoft Fabric Community
Best Regards,Dino TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Power BI Rest API via Web query

2 Replies

Related content

Power BI REST API's

Power Query REST API error

Power Query dates

Query activity runs REST API

Data transform using power query