Dataset refresh failed

[kasparsveveris]

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":"Single sign-on (SSO) credential is not provided which is required to execute the current request. Note that performing a refresh over a dataset with a calculated table or a calculated column which references a Direct Query data source is not supported within the Power BI service."}}]}}}

Any ideas?

[Anonymous]

Hi @kasparsveveris ,

According to your error message.You have used Direct Query connection mode in Power BI to connect to a datasource with a calculated column or a calculated table, which is currently not supported within the Power BI service.

• Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used.
• Calculated tables: You can use calculated tables in DirectQuery when using composite models.

For more information, you can refer to：Modeling limitations - About using DirectQuery in Power BI 

Or you can consider using another connection method to connect to your data source：

Dataset modes in the Power BI service 

Using DirectQuery for Power BI datasets and Azure Analysis Services (preview) 

Best Regards,
Community Support Team _ Caitlyn

[kasparsveveris]

Nope. Dataset does not have any calculated table. There are 2 tables made with SUMMARIZE, but in other report with those 2 tables refresh works fine.

[Anonymous]

Hi @kasparsveveris ,

This is a documented limitation:

Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs

• Calculated tables are not supported in the Service using this feature. Attempting to perform a refresh on a dataset with a calculated table or a calculated column which references a Direct Query data source will result in a "Single sign-on (SSO) credential is not provided" error message.

Best Regards,
Community Support Team _ Caitlyn