Azure Event Hub to PowerBI: "credentials contained in the authorization header are not in the WRAP"

[Anonymous]

Hi all:

I have created an Event Hub that gathers tweets. That's working fine.  I want PowerBI to grab that information and do something with it.  Using the web key/URL model, I get a credential error.

Using Python, I believe the error I am getting is "The credentials contained in the authorization header are not in the WRAP format."  Has someone seen this problem before?  

Is there a way in PowerBI I can check to see why my Azure Authentication isn't working?

[konstantinos]

Probably not useful to your situation but if is  Azure event hub there is a powerbi output in the old Azure portal from managing event hub

[Anonymous]

Yeah, I saw that.  It requires a PowerBI enterprise/work account and didn't "play nicely" with PowerBI Desktop, unfortunately.  I'm trying a hack-around of Streaming the Event Hub to a SQL DB and polling the data from there, but it ain't pretty.

EDIT: well, I would hardly call my hack an "accepted solution."  Can that be un-done?

[Anonymous]

I guess, asked otherwise, is there a way to see the Error Logs from when an oAuth connection fails?

[v-qiuyu-msft]

Hi @Anonymous,

The error message "The credentials contained in the authorization header are not in the WRAP format" indicates that the authorization header sent to Azure use the wrong format. The required format is WRAP format, which should look like below: 

Authorization: WRAP access_token=”123456789”

You can take a look at this article: 4.2 Client Calls Protected Resource Using HTTP Header.

In your scenario, please try to use Fiddler to track local request and Azure response to see if you can find anything. Also please take a look at this article: Stream Analytics & Power BI: A real-time analytics dashboard for streaming data.

By the way, you can unaccept the solution if the issue hasn't been solved.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu