Dataset not refreshing via API in Power BI web service& headers not being paased

[Idrisaurangzeb]

Hello,

I have setup a new datasource in PowerBI desktop to get data over an API (see below).

Everthing works fine locally, and I'm able to refrersh the data in PBI desktop, however when I publish the report to PBI web, and try to refresh the data, I receive the following error; 

The credentials you provided for the data source are invalid. Please check the credentials for all the data sources.
Please try again later or contact support. If you contact support, please provide these details.

I have no idea as to why the headers are not being passed through to the PBI Web.

This is what I see see in PBI web;

Please help! 

[luchitogiuse]

@Jayendran Thanks you a lot!! it worked! thanks!! 

[Jayendran · Accepted solution]

Hi @Idrisaurangzeb 

Please see my answer in the below link.

https://community.powerbi.com/t5/Service/Refreshing-data-from-REST-API-works-on-Desktop-fails-on-Ser...

Your api is using api-key autentication which is not currently directly supported by PowerBI service. Bcoz PowerBI Service only allow API autentication with anonymus , Windows and Basic

The workaround is to use a Gateway and Skip Test Connection 

https://community.powerbi.com/t5/Community-Blog/Power-BI-Gateway-Monitoring-amp-Administrating-Part-...

[robjbow]

Jayendran, I read your follow up article but this did not work. I was wondering if you were referring to a Personal Gateway vs an Enterprise Gateway for this particular post? Did you mean this will work via a Personal Gateway?

[Jayendran]

Hi @robjbow , I was referring to enterprise gateway and not the personal one