cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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

Accepted Solutions
Super User II
Super User II

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

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

 

 







Did my reply helpful to you ? Please give Kudos

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
Super User II
Super User II

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

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

 

 







Did my reply helpful to you ? Please give Kudos

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Kudoed Authors