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
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.