Data source error

[Anonymous]

When I open my dashboard in desktop version it works fine, but when my published version auto-refreshes, I get this message. "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. " Does anyone know how to fix this? Thank you.

[tackytechtom · Accepted solution]

Hi @Anonymous ,

I found this one here:

• Limitations in calculated columns: Calculated columns can only be intra-row, that is they can refer only to values of other columns of the same table, without using any aggregate functions. Also, the allowed DAX scalar functions, such as LEFT(), 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 query for a calculated column, and result in an error if used.

Do you do any of this? 

Maybe you can create those tables and columns in Power Query instead? 🙂 Or use import?

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/