Forum Discussion

SBX's avatar
SBX
Frequent Visitor
1 year ago

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

Hi all,  I've created a Power BI report where I've imported two reports from the service (via direct query). These imported models probably have some calculated fields/ tables, hence I'm getting the error below. I know Power BI doesn't support refresh for calculated fields on direct query mode, but I'm hoping there is a solution to this in 2025. I do not want to re-create the same reports via import mode, as that is just duplicating work. There must be an easier way??  

Thanks

 

Data source error{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"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."}}],"exceptionCulprit":1}}}

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • freginier's avatar
    freginier
    Icon for Solution Sage rankSolution Sage
    1 year ago

    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!

    😁😁

  • SBX's avatar
    SBX
    Frequent Visitor
    1 year ago

    Thanks, but not the solution I was looking for.

    Anyways, the requirements have changed, so I no longer need the report.