Failed to Refresh the Semantic Module

[SurendraD]

Hi All,

I am trying to refresh the module in powerbi service but it is failing to refresh and below is the error.

error:

Last refresh failed: 4/17/2024, 6:21:04 PM
There was an error when processing the data in the dataset.Hide details

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}}}

can any one please help to get this fix 
@dax @Solver @PowerBI @jp_upbservices @daxdax @daxdaxdax 

[Anonymous]

Hi @SurendraD ,

The problem is "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."

So I think you need to ensure that the data source is not using SSO with Direct Query. Also if there are calculated tables or columns that depend on a DirectQuery source, consider changing them to use imported data or adjusting the DAX formulas.

If you’ve recently made changes to your data model or the way data is accessed, it might have affected the refresh capability. Review any recent changes and adjust accordingly. I think you can read this topic for a further study: Solved: PowerBI dataflow refresh failed due to Premium_AS... - Microsoft Fabric Community

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.