Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PowerBI Usage metrics report stops refreshing

Hello,

 

I'm facing a recurring issue with the usage metrics report dataset: it stops refreshing.

I know that deleting and creating a new one solves the issue, but only temporaly, since it's the third time it happened this past weeks.

Seems like the problem is that the credentials within the dataset somehow expired and they need to be updated, but I can't see the dataset itself for me to do it.

I found this old topic with the same issue: https://community.fabric.microsoft.com/t5/Service/Metric-usage-report-with-update-outdated/m-p/2481848#M158605

But, as I said, I can't see the dataset on the menu.

 

Here's a print of the refresh warning oh the metrics report.

I used the API to get a refresh history and here's the error causing this:

 

"serviceExceptionJson": "{\"errorCode\":\"ModelRefresh_ShortMessage_ProcessingError\",\"errorDescription\":\"{\\\"error\\\":{\\\"code\\\":\\\"DMTS_OAuthTokenRefreshFailedError\\\",\\\"pbi.error\\\":{\\\"code\\\":\\\"DMTS_OAuthTokenRefreshFailedError\\\",\\\"parameters\\\":{\\\"ConnectionDetails\\\":\\\"{\\\\\\\"kind\\\\\\\":\\\\\\\"UsageMetricsDataConnector\\\\\\\",\\\\\\\"path\\\\\\\":\\\\\\\"UsageMetricsDataConnector\\\\\\\"}\\\",\\\"CredentialType\\\":\\\"OAuth2\\\",\\\"DatasourceType\\\":\\\"Extension\\\"},\\\"details\\\":[{\\\"code\\\":\\\"DM_ErrorDetailNameCode_UnderlyingErrorMessage\\\",\\\"detail\\\":{\\\"type\\\":1,\\\"value\\\":\\\"AADSTS50173: The provided grant has expired due to it being revoked, a fresh auth token is needed. The user might have changed or reset their password. The grant was issued on '2023-05-22T11:45:07.2426383Z' and the TokensValidFrom date (before which tokens are not valid) for this user is '2023-06-02T18:28:06.0000000Z'.\\\\r\\\\nTrace ID: 303730fb-15a9-4311-9819-871a65e3a801\\\\r\\\\nCorrelation ID: 61ee2ecb-d4e6-40dc-b4d2-20d344f32951\\\\r\\\\nTimestamp: 2023-06-06 01:55:13Z\\\"}},{\\\"code\\\":\\\"DM_ErrorDetailNameCode_UnderlyingErrorMessage\\\",\\\"detail\\\":{\\\"type\\\":1,\\\"value\\\":\\\"AADSTS50173: The provided grant has expired due to it being revoked, a fresh auth token is needed. The user might have changed or reset their password. The grant was issued on '2023-05-22T11:45:07.2426383Z' and the TokensValidFrom date (before which tokens are not valid) for this user is '2023-06-02T18:28:06.0000000Z'.\\\\r\\\\nTrace ID: 303730fb-15a9-4311-9819-871a65e3a801\\\\r\\\\nCorrelation ID: 61ee2ecb-d4e6-40dc-b4d2-20d344f32951\\\\r\\\\nTimestamp: 2023-06-06 01:55:13Z\\\"}},{\\\"code\\\":\\\"DM_ErrorDetailNameCode_UnderlyingHResult\\\",\\\"detail\\\":{\\\"type\\\":1,\\\"value\\\":\\\"-2146233088\\\"}}],\\\"exceptionCulprit\\\":1}}} Table: Report page views.\"}",
"status": "Failed"

 

 

I really don't know what to do since I can't see the dataset itself nor I found a API call to manually refresh the credentials attached to the dataset.

3 Replies

  • Abandon these reports and use the tenant audit logs instead.

  • Anonymous's avatar
    Anonymous
    Not applicable

    I'm searching more informations about these audit logs. I would need admin permission to access them, right?