Forum Discussion
SantiagoRodrig
2 years agoNew Member
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
- parry2kSuper User
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.