cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Idrisaurangzeb
Regular Visitor

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

Hello,

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

API Issue.PNG

 

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;

PBI Web.PNG

 

Please help! 

1 ACCEPTED SOLUTION
Jayendran
Solution Sage
Solution Sage

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-...

 

 

View solution in original post

3 REPLIES 3
Jayendran
Solution Sage
Solution Sage

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-...

 

 

View solution in original post

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?

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

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors