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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
daniel_digi
New Member

Web.Content API Call failing in main editor but not Query Editor

I have built a report that utilises Web.Contents to make calls to several endpoints of an API. Using the Relative Path method (see snippet) I have been able to sucessfully publish the report to the web and it has been working for several months.

 

AccessTokenHeader = "bearer " & ClientAccessToken, 
 GetJson = Web.Contents(api_uri,
     [
         RelativePath = "api/1.1/xxx",
         Headers = [#"Authorization"=AccessTokenHeader]
     ]
 )

 

About a week ago I started receiving the following error: The credentials provided for the Web source are invalid. (Source at https://api.xxx.com.au/api/x.x/xxx/xxx/xxx)

 

I opened the report in Power Bi Desktop and received the same error when doing a refresh in the main editor. Interestingly across multiple refreshes the endpoint that presents the error can change. 

 

However, if I open the Query Editor and individually refresh the queries they all return data without issue. If I do this and then click Close and Apply it starts the refresh and eventially the prompt for me to choose how to authenicate appears. I pick anonymous and it then fails. 

 

Has anyone had a similar experience?

3 REPLIES 3
mahoneypat
Microsoft Employee
Microsoft Employee

Do you know that the token hasn't expired or hasn't been deactivated?

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


The token gets regenertated each time the dataset gets refreshed so I don't think it would be related to this.  

daniel_digi
New Member

UPDATE: After going back in the Query Editor after attempting the refresh in main editor is now failing in Query Editor as well. 

 

So now I am ever more confused as to why this has stopped working.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.