Solved: Data Model Refresh error

arjunjalan · ‎03-12-2024

Hi,

UI have a Power BI Dataflow, Model & Report I am trying to chain via deployment pipelines. However, I am getting an error when updating the model in the Test environment.

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: 5768f3a0-680a-4456-baa5-501da2f78700 Correlation ID: 3f959e9e-29ec-402f-a483-0919a07759e7 Timestamp: 2024-03-12 13:13:39Z"}}],"exceptionCulprit":1}}} Table: Dim-WeeklyPeople.
Cluster URI: WABI-US-NORTH-CENTRAL-D-PRIMARY-redirect.analysis.windows.net
Activity ID: 88b270d8-b7f2-47fe-b467-4d18bd4e1453
Request ID: 0f19fa3e-2ca6-3349-171b-404b1fb90da4
Time: 2024-03-12 13:13:39Z

My deployment pipeline is Dev->Test->Prod.

Thanks!

Arjun

Anonymous · ‎03-13-2024

Hi, @arjunjalan

According to your description, there is an error with the data model refresh in the Power BI deployment pipeline. This error typically indicates a problem with the OAuth token used for authentication, which may be related to expired or invalid credentials or the configuration of the data source in the Power BI service. You can try the following to resolve the issue.

1. Verify the data source credentials. Make sure that the credentials for the data source in your test environment are up to date; verify that the OAuth token is not expired. If it has, you may need to re-authenticate.
2. Ensure that the server name in the gateway data source and PBIX file uses the fully qualified domain name (FQDN) of the server.
3. If you are using a local data gateway, ensure that it is properly configured and linked to the Power BI service (verify that the gateway is online and that there are no pending updates).

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

View solution in original post

Anonymous · ‎03-13-2024

Hi, @arjunjalan

According to your description, there is an error with the data model refresh in the Power BI deployment pipeline. This error typically indicates a problem with the OAuth token used for authentication, which may be related to expired or invalid credentials or the configuration of the data source in the Power BI service. You can try the following to resolve the issue.

1. Verify the data source credentials. Make sure that the credentials for the data source in your test environment are up to date; verify that the OAuth token is not expired. If it has, you may need to re-authenticate.
2. Ensure that the server name in the gateway data source and PBIX file uses the fully qualified domain name (FQDN) of the server.
3. If you are using a local data gateway, ensure that it is properly configured and linked to the Power BI service (verify that the gateway is online and that there are no pending updates).

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

arjunjalan · ‎03-14-2024

Hi Yang,

Thanks for the input! I had rewired the accompanying data flow with the right credentials but had to update the said dataflow credentials in the data model itself, works well now!

Best,

Arjun