No Authorisation REST API after Publish Header

[MennoTwill]

Hi all,

I have designed a dashboard within Power BI Desktop using our own data. This data is accessed using a REST API which is authorized using a token in the header. Everything works fine, but then I publish to Power BI Services and want to schedule the refresh. It shows a 400 error. It seems to be that the header is lost during publish?

I checked for hours on forums, but couldn't find any real solution. The only thing I found was this topic (https://community.powerbi.com/t5/Service/web-contents-with-specified-headers-works-in-PBI-desktop-bu...) but without any solution. Can someone help me to fix this final piece?

Thanks in advance.

[v-yuezhe-msft]

@MennoTwill,

Could you please post the power query code in Advanced Editor of your query for us to analyze? Do mask sensitive data before you upload code.

In addition, please review my reply in  the similar thread below and check if it helps you.
http://community.powerbi.com/t5/Integrations-with-Files-and/Dataset-Refresh-REST-API-amp-JSON-with-r...

Regards,
Lydia

[MennoTwill]

Thanks for your reply.

I read the topic you are mentioning and changed the code. This code works in Power BI Desktop, but still not on Power BI Services.
This is the code I'm originally using to connect:

Source = Json.Document(Web.Contents("URL", [Headers=[Authorization="API KEY"]]))

I also split it into the URL + relative path, but that doesn't work either. And I changed it to have Web.Contents on one row and Json.Document at the second, but that also didn't work that well.

Hope someone can help me to solve it.

[v-yuezhe-msft]

@MennoTwill,

Do you use any parameter in the URL?

Regards,
Lydia

[MennoTwill]

@v-yuezhe-msft No, it is just a normal url like: www.google.com/api/v3/information

[Phoenixke]

@MennoTwill Would try with #"Authorization"="key" in your header.

There is also an option in Options and settings > Options > Privacy that I've had to set to 'Always Ignore Privacy Level settings' for it to work.