Forum Discussion

Chanakya_vcr's avatar
Chanakya_vcr
Helper II
1 year ago
Solved

Refresh Failure for Live Connection

Hello Everyone, receiving below error: 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 ...
Need Help
  • Abhilash_P's avatar
    Abhilash_P
    1 year ago

    Hi Chanakya_vcr ,

    For the specific workspace enable below options

    In General Tab

     

     

    In Data Connectins tab



    Thanks

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi Chanakya_vcr  - it is due to the use of calculated tables or columns in combination with a Single Sign-On (SSO)-enabled DirectQuery connection.

Power BI does not allow these calculations in combination with SSO-based DirectQuery, as it can’t securely evaluate those calculations during refresh.

 

suggest you, If possible, switch from DirectQuery to Import mode for the dataset.This avoids SSO limitations and supports calculated tables/columns.

⚠️ This works only if your data doesn’t need to be live.

 

DirectQuery in Power BI - Power BI | Microsoft Learn

Overview of single sign-on for on-premises data gateways - Power BI | Microsoft Learn

 

Hope this helps.