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

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi Chanakya_vcr I think this occurs because calculated tables or columns are not supported with Single Sign-On (SSO) in a live connection. Switch to Import Mode or reconfigure the dataset to use DirectQuery with explicit credentials. Alternatively, move the calculated table logic to Power Query or use DAX measures instead. If the issue persists, contact Microsoft Support with the provided Activity and Request IDs.