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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Yumare41
Frequent Visitor

DMTS_OAuthFailedToGetResourceIdError

Hello, Since Friday, March 24, first thing in the morning, I am presenting the following error for updating reports in Power BI:


Data Source Error:{"error":{"code":"DMTS_OAuthFailedToGetResourceIdError","pbi.error":{"code":"DMTS_OAuthFailedToGetResourceIdError","parameters":{},"details":[]," exceptionCulprit":1}}} Table: XXXXX.
Cluster URI: WABI-PAAS-1-SCUS-redirect.analysis.windows.net
Activity ID: c7d732e7-cfdf-4df1-ab52-81e67339d928
Request Identifier: 9dc39375-cecd-42db-bbba-42ae349fe833
Time: 2023-03-24 20:30:57Z

 

All the data comes from a database in SQL and no change has been made, I can update and publish from Power BI desktop but the changes are not reflected on the web, every time I try to update the error points to a table that is not the only base. I already tried entering the database credentials again and it still doesn't work. Thank you!

 

1 ACCEPTED SOLUTION
Yumare41
Frequent Visitor

Hello,

We fixed this by entering the source credentials again,

Changing the PRIVACY LEVEL FOR THIS DATA SOURCE to private,

And deselecting Report viewers can only access this data source with their own Power BI identities using DirectQuery.

 

After that update normal

 

Yumare41_1-1679946007547.png

 

View solution in original post

6 REPLIES 6
Yumare41
Frequent Visitor

Hello,

We fixed this by entering the source credentials again,

Changing the PRIVACY LEVEL FOR THIS DATA SOURCE to private,

And deselecting Report viewers can only access this data source with their own Power BI identities using DirectQuery.

 

After that update normal

 

Yumare41_1-1679946007547.png

 

dbeavon3
Responsive Resident
Responsive Resident

I had a recent support case about DMTS_OAuthFailedToGetResourceIdError.   I recommend that anyone encountering this should open a support case.  There shouldn't be any "legitimate" reason for encountering the error, and it is almost certainly a Microsoft bug.

 

In many cases, it may be due to enabling SSO features on your underlying data source.  The best way of avoiding problems is to AVOID enabling any fancy/fragile features.

 

In my case the outage lasted a whole week before the PG team was able to recover from this problem.  There is a lot at stake, especially if your Power BI reports are mission-critical.

 

Below is an explanation from CSS. I'm not 100% certain how to understand this explanation of the bug, other than to point out that oauth refresh tokens weren't properly renewed.  Power BI was only partially to blame, since a day-long outage of Azure SQL (in East US) probably exposed an underlying PBI bug that had previously remained hidden .

 

"we have checked internally for the Root cause of the issue and found that there was a bug where an s2s token is not being passed when creating a VNet gateway client for discovering the Oauth Resources and also the Refresh token was not getting renewed due to which this issue has occurred.

This prevents customers from refreshing their reports that point to a VNet gateway."

Boa tarde.
Resolveu meu problema com as atualizações.

o365lp2
New Member

I have the same problem!
Today all my dashboards show the same error, is it a general problem?

o365lp2_0-1679933148688.png

 

ReubenS
Advocate I
Advocate I

Hi ,

 

Just wanted to check is the database your connecting to Autotask?

 

Kind regards,

Reuben

Hello, no this base is not connected to Autotask.

 

Greetings!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.