Forum Discussion

SantiagoRodrig's avatar
SantiagoRodrig
New Member
2 years ago

Direct Query refresh error when there are calcualted tables

I recentyl heard that the May 2024 Power BI version will enable us to create calculated tables and have the schedule refresh option to refresh the report. I got an error meaning that this is not avilable yet

 

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

1 Reply

  • SantiagoRodrig have you added a cloud connect with the option "Use SSO via Azure AD for DirectQuery", I think it is required to make it work.