Forum Discussion

MathFR's avatar
MathFR
New Member
10 months ago
Solved

Calculated table update

Hello All   Since last week I've an issue when I try to refresh my Power BI.    All of the tables are from an SQL server  and I copy past them to built many calculated columns (DAX), It's works s...
Need Help
  • Ahmed-Elfeel's avatar
    Ahmed-Elfeel
    10 months ago

    Hi MathFR ,

    I hope your day is great 😍....

     

    Ok lets dive into your question...At First your issue can occur after Power Bi updates!

    • The problem is that your calculated tables are not refreshing properly after the SQL data updates.

    So try this solutions:

    First Solution: Power BI Version

    • My first suggestion is going to check you PowerBi Compatibility.
    • If the report is very important (Download an old version of Power bi Desktop and try the July version its likely 2.145.1105.0)

    Second Solution: Full Refresh

    • Go to Home > Refresh > Refresh (not Refresh all)

    • If you find any issue when refreshing...Remove any permissions (Transform data > Data source settings > Clear Permissions)
    • Also you can try Clearing cache (Options and settings > Data Load > Clear Cache)

    Third Solution: Review Calculated Table

    • Check if any SQL table schema changes affected your DAX formulas
    • Verify relationships between imported and calculated tables

    Fourth Solution: Check DAX Formula

    • Verify DAX formulas still work with current data structure
    If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
AMD0791's avatar
AMD0791
Advocate IV
10 months ago

Please update if you find a solution.  I have a user seeing a similar issue.  In our case, the calculated tables are built on tables in another semantic model.  There isn't a "Refresh" option on the right-click context menu for that calculated table, and the "Refresh" options in the main ribbon don't reliably update the table.  The work-around seems to be to edit the DAX for the calculated table to force a refresh.

 

This definitely seems to be related to the September release.

Ahmed-Elfeel's avatar
Ahmed-Elfeel
Super User
10 months ago

Hi AMD0791,

I provided a step by step Solution you can review it 😅

 

In Your Case it can be :

  • Calculated tables built on other semantic models are not refreshing properly

  • Ribbon refresh is unreliable

  • September update is the common factor

So Verify DAX:

  • Open calculated table DAX

  • Make minor change (add space or comment)

  • Save and forces refresh

Clear Cache:

  • File → Options → Data Load → Clear Cache

  • Restart Power BI

Rollback to July Version:

 

f this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.