cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mata1923
Regular Visitor

DMTS_OAuthFailedToGetResourceIdError

Hi,

 

For some reason reports that we are using have started to fail their refresh. I didnt make any changes to our reports, neither did our IT department. To my understandin, this problem started to occur randomly (a report that wasnt refreshed 2 hrs ago might get refreshed after, but then fails to refresh again randomly later on). And I'm having trouble to find a solution to fix the issue. We connect to data source with "Import" option from SQL DWH with an on-premises data gateway on a local computer. Also we have excel files that takes the data from a public network folder and tranfers it to respective reports. There is no problem while refreshing the report from desktop but It gives the error on refreshes coming from app.powerbi.com website.

 

Kindly ask for your comments and assistance.

 

Mata1923_0-1679896487885.png

 

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_0-1679945810454.png

 

View solution in original post

1 REPLY 1
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_0-1679945810454.png

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Kudoed Authors