Premium_ASWL_Error

[Anusha__v]

Hi,

The reports were working fine for a couple of months, but yesterday I suddenly got this error below.

The reports were not showing in both the Power BI Service and Embedded application. After we re-entered the credentials on the embedded application, this error went. When we re entered credential server name we give without the port number.

What was the reason this issue occurred suddenly?

Data source error:	{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"We cannot refresh this dataset because the dataset contains calculated tables or calculated columns based on data from a Single Sign-on (SSO)-enabled Direct Query data source. Please configure the dataset to use an explicit connection with granular access control to access this data source and then try again."}}],"exceptionCulprit":1}}}
Cluster URI:	WABI-US-EAST2-redirect.analysis.windows.net
Activity ID:	a13987f1-b35a-4c58-b758-96352945dea4

[v-achippa]

Hi @Anusha__v,

Thank you for reaching out to Microsoft Fabric Community.

Here this error indicates that the semantic model contains calculated tables or calculated columns based on an SSO enabled DirectQuery data source, which is not supported for refresh.

• Since the issue was resolved after re-entering the credentials, it looks like the issue is with the data source connection or authentication was revalidated. If the issue occurs again, please verify that the dataset is configured to use an explicit connection with granular access control instead of SSO.

For reference, follow the below documentation:

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

Thanks and regards,

Anjan Kumar Chippa