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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mjbernier
Helper II
Helper II

Authentication error when refreshing API dataset

I have a report which has been running for almost four years that uses multiple API calls to a cloud service to pull in several different data elements in both JSON and CSV formats. These data sources are on a nightly scheduled refresh and have been working just fine until recently. I noticed as I was asked to look into an upcoming modification that the refreshes are now failing with an error stating the credentials are not valid. Thinking the bearer token in the connection string may have expired, I opened my local copy of the report in Desktop and tested the connection, and it worked just fine.

 

The only notes I can find refer to PBIRS not supporting Web.Page and Web.BrowserContents methods for scheduled refresh, but this connection uses Web.Contents, which is supported. The connection authentication is Anonymous as the bearer token is embedded in the connection string, and this has been working until I noticed this issue.

 

Has something changed in how the Report Server manages these types of connections? It's imperative I find a solution as my client is somewhat anxious to have their reporting stay up to date, and will have an effect on the future development they are considering.

3 REPLIES 3
SusanC
Regular Visitor

I am having the same issue, with credientials and datasets not refreshing 

lbendlin
Super User
Super User

Since you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

Thanks for the suggestion... I hadn't thought of that. Usually this forum has been really good at helping me find answers, but this one's knocking us for a loop. I'll open a ticket.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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