Forum Discussion

jscivias's avatar
jscivias
Icon for Helper I rankHelper I
2 years ago
Solved

Unable to update PBI dataset through Power Automate 'refresh dataset'

hello, I have a Power BI dashboard that is published on a premium workspace, i've been manually publishing udpates through Power BI Desktop but just tried createing a simple flow using Power Automate that first refreshes my dataflow (refreshes fine) then updates the PBI file that imports data from said dataflow:

 

 

the flow runs to the end successfully, and when i check my pbix file it shows as being refreshed, but with an alert sign next to the semantic model file:

 

 

the error message is:

 

  • Data source error{"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS9002313: Invalid request. Request is malformed or invalid. Trace ID: 14d2674a-0fb5-41f1-a994-bfbc17934200 Correlation ID: d05a2fd4-89fa-46e4-9285-1bab74377123 Timestamp: 2024-03-13 16:01:39Z"}}],"exceptionCulprit":1}}} Table: xxxx
  • Cluster URIWABI-CANADA-CENTRAL-redirect.analysis.windows.net
  • Activity ID00000000-0000-0000-0000-000000000000
  • Request ID29e214fa-7c28-47d9-8653-2ef1c0ebd97a
  • Time2024-03-13 16:01:39Z

 

I tried running the flow several times and noticed that the error message always refers to a different table xxxx, all of which are excel files stored on our sharepoint folder (not related to the dataflow data). Anyone have any tips on how to fix this issue? Thank you

 

2 Replies