Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
collinq
Super User
Super User

Refresh a report using Power BI Rest API - NOT using API to refresh a report

Hi all,

I have a desktop report that is using the Power BI rest api. 

Example:

My desktop report has the source as = Json.Document(Web.Contents("https://api.powerbi.com/v1.0/myorg/groups/zzzzzzee9f8-d046-3a-8ad2-ae746e17a5ec%2F/reports", [Headers=[Authorization="xxxxxxxx"]]))  

 

This works fine - I am getting the list of all of the reports in that workspace.

 

I publish this to the Service.

 

I understand that I have to use "anonymous" but I keep getting messages like "failed to update data source credentials: the credentials provided forthe Web source are invalid...."

 

What am I doing wrong?




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @collinq ,

Please try to connect to your REST API using Web connector, and switch to Advanced setting page.  To add HTTP request header parameter: Authorization just as Figure 1. The parameter value can get from the related rest API page as Figure 2.

yingyinr_0-1630653725802.png

 

yingyinr_3-1630653941546.png

Then please refer the solution in the following links to resolve the invalid credentail error.

Power BI: Using anonymous authentication on Web data sources with a API key in URL


update the data source from API to the Proxy


Anonymous access

Best Regards

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @collinq ,

Please try to connect to your REST API using Web connector, and switch to Advanced setting page.  To add HTTP request header parameter: Authorization just as Figure 1. The parameter value can get from the related rest API page as Figure 2.

yingyinr_0-1630653725802.png

 

yingyinr_3-1630653941546.png

Then please refer the solution in the following links to resolve the invalid credentail error.

Power BI: Using anonymous authentication on Web data sources with a API key in URL


update the data source from API to the Proxy


Anonymous access

Best Regards

 

 

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.