All Datasets can't refresh in all environments
This is the error on one of the datasets. I bolded the path for one report but the others could be SharePoint, CRM, SQL...doesn't matter. Where can I reset everything and get the refresh working again?
| Data source error: | {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DMTS_OAuthTokenRefreshFailedError","parameters":{"ConnectionDetails":"{\"kind\":\"Kusto\",\"path\":\"Kusto\"}","CredentialType":"OAuth2","DatasourceType":"Extension"},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS53000: Device is not in required device state: compliant. Conditional Access policy requires a compliant device, and the device is not compliant. The user must enroll their device with an approved MDM provider like Intune.\r\nTrace ID: 05ee299f-d446-4a24-b559-e59a07612603\r\nCorrelation ID: dd65bc2d-1631-41de-8d69-b958f42d09ea\r\nTimestamp: 2022-12-05 16:26:08Z"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AADSTS53000: Device is not in required device state: compliant. Conditional Access policy requires a compliant device, and the device is not compliant. The user must enroll their device with an approved MDM provider like Intune.\r\nTrace ID: 05ee299f-d446-4a24-b559-e59a07612603\r\nCorrelation ID: dd65bc2d-1631-41de-8d69-b958f42d09ea\r\nTimestamp: 2022-12-05 16:26:08Z"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2146233088"}}],"exceptionCulprit":1}}} Table: OfferingCertOffice. |
| Cluster URI: | DF-MSIT-SCUS-redirect.analysis.windows.net |
| Activity ID: | 852f85d8-03ce-9401-4b93-dbe98c8d8ce4 |
| Request ID: | fde9fe0f-f58d-8a96-2ea5-3794a7152249 |
| Time: | 2022-12-05 16:26:09Z |
3 Comments
- AnonymousNot applicable
Hi Anonymous ,
Please open "dataset -settings" to check credentials and gateways configuration.
Best regards,
Community Support Team Selina zhu
- AnonymousNot applicable
Anonymous Yep, that is one of the first things I did and tried to log in by using the Edit credentials. it fails there too. Using Organizational as the privacy level. One of our engineers is owner of the datasets. And the Gateway Connection does not expand to show me anything.
- TorsteinENew Member
Are having the same issue after the user is enroled into Compliance Device rule in Conditional Access. After they was removed from this rule, everything worked fine.
What do we need to exclude to make it work?