Data refresh failure due to calculated fields/tables dependant direct query mode

Hey there!

Since Direct Query Mode does not support calculated tables, consider:

- switching the report to Import Mode.
- Refreshing the dataset manually.
- Recreating calculated fields within the data source (SQL, etc.) instead of Power BI.
How to do this:

- Go to Power BI Desktop → Transform Data.
- Select the dataset → Change Storage Mode.
- Choose Import instead of Direct Query.

Also, instead of creating calculated columns in Power BI, move them to your SQL Server database.
- Write the calculation directly in SQL (Views or Stored Procedures).
- Then, load the results into Power BI as a normal column.

Also since the error mentions SSO, check:
- Go to Power BI Service → Dataset Settings.
- Look under "Data source credentials".
- If SSO is enabled, try disabling it and re-authenticate.

Hope this helps!

😁😁