Forum Discussion

Idrisaurangzeb's avatar
Idrisaurangzeb
Regular Visitor
6 years ago
Solved

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).   Everthing works fine locally, and I'm able to refrersh the data in PBI desktop, however when I ...
Need Help
Jayendran's avatar
Jayendran
Solution Sage
6 years ago

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-Service/td-p/779926

 

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-2/ba-p/750765 

 

 

robjbow's avatar
robjbow
Regular Visitor
5 years ago

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's avatar
    Jayendran
    Solution Sage
    5 years ago

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