Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Status: Investigating

Hi @gsauers ,

 

Please open "dataset -settings" to check credentials and gateways configuration.

vmengzhumsft_0-1670394689981.png

 

Best regards,

Community Support Team Selina zhu

Comments
v-mengzhu-msft
Community Support
Status changed to: Investigating

Hi @gsauers ,

 

Please open "dataset -settings" to check credentials and gateways configuration.

vmengzhumsft_0-1670394689981.png

 

Best regards,

Community Support Team Selina zhu

gsauers
Employee

@v-mengzhu-msft 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.

 

gsauers_0-1670519620448.png

 

TorsteinE
New 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?