Forum Discussion

BethM's avatar
BethM
New Member
7 months ago
Solved

Auto Refresh

I have a dashboard that I have created, connected through the web to a spreadsheet that is saved on Sharepoint. I have published to Power BI service and the auto-refresh keeps failing and giving me the below error.

 

Data source error: {"error":{"code":"DMTS_OAuthFailedToGetResourceIdError","pbi.error":{"code":"DMTS_OAuthFailedToGetResourceIdError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Failed to get OAuth resource, please make sure the OAuth is supported"}}],"exceptionCulprit":1}}}
Cluster URI: WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
Activity ID: b989a7a5-3a43-43f2-8c25-c7f88cb5b843
Request ID: 123f4f9e-729b-40a1-8513-2752c0fec846
Time: 2026-01-15 13:39:12Z

 

I have tried everything I can think of (+ everything Copilot has suggested) and I still can't seem to find the solution. My boss needs this to be up and running by next week...can anybody help please?

Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    7 months ago

    Hello BethM,
    Thank you for the update and we really appreciate you confirming that.

    Based on everything shared so far, the behavior aligns with a Web-based SharePoint connection, which isn’t supported for reliable OAuth refresh in the Power BI Service. Resolving it requires rebuilding the dataset using the native SharePoint/OneDrive connector and republishing.

    Best regards,
    Ganesh Singamshetty.

10 Replies

  • tayloramy's avatar
    tayloramy
    Super User
    7 months ago

    Hi BethM, 

     

    Is the data source properly set up in the semantic model? 
    Can you post some screenshots of the data source settings? 

     

    It looks like it is failing to get the OAuth token. 

     

    • BethM's avatar
      BethM
      New Member
      7 months ago

      Hi tayloramy 

      I'm guessing looking at this screenshot that its not.

       

       

      I'm very new to Power BI so I seem to be learning as I go. May I ask what it should look like?

  • tayloramy's avatar
    tayloramy
    Super User
    7 months ago

    Hi BethM, 

     

     If you go to the settings of the model: 

    you should be able to see the gateway and cloud connections, and the data source creentials settings: 

     

     

     

    • BethM's avatar
      BethM
      New Member
      7 months ago

      This is what I see when I follow your steps

  • tayloramy's avatar
    tayloramy
    Super User
    7 months ago

    Hi BethM, 

     

    Okay, so you're not using any gateway or anything. If you scroll down a little more and go to the data source settings, you can edit the credentials to ensure they are up to date. 

     

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    7 months ago

    Hi BethM,

    Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to tayloramy for sharing valuable insights.

     

    Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

     

    Thank you for being part of the Microsoft Fabric Community.

     

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    7 months ago

    Hello BethM,

    We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

    Thank you.

     

    • BethM's avatar
      BethM
      New Member
      7 months ago

      v-ssriganesh My apologies I have been OOO.

       

      Unfortunately, my issue is still occuring but the information/answers I have been given on this thread have been invaluable.

  • v-ssriganesh's avatar
    v-ssriganesh
    Community Support
    7 months ago

    Hello BethM,
    Thank you for the update and we really appreciate you confirming that.

    Based on everything shared so far, the behavior aligns with a Web-based SharePoint connection, which isn’t supported for reliable OAuth refresh in the Power BI Service. Resolving it requires rebuilding the dataset using the native SharePoint/OneDrive connector and republishing.

    Best regards,
    Ganesh Singamshetty.

    • v-ssriganesh's avatar
      v-ssriganesh
      Community Support
      7 months ago

      Hello BethM,

      Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

      Thank you.