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.
v-menakakota's avatar
v-menakakota
Community Support
10 months ago

Hi MathFR ,

Thanks a lot for sharing the update, I understand how frustrating this must be. You’re right, this issue seems to have started after the September Power BI Desktop update, and a few other users have reported the same problem with calculated tables not refreshing correctly.

Here are a few things you can try for now:

 

Full refresh: Go to Home > Refresh > Refresh all instead of just “Refresh.”

 

Clear cache: Try File > Options and settings > Data Load > Clear cache, then restart Power BI Desktop.

 

Check the DAX: Open the calculated table DAX, make a small change (like adding a space), and save this forces a refresh.

 

Older version (temporary fix): If possible, use the July version (2.145.1105.0) until this bug is fixed in a later update.


Thank you.

v-menakakota's avatar
v-menakakota
Community Support
10 months ago

Hi @MathFR ,

Can you please confirm whether the issue got resolved or else facing the same.

Thank you.

  • v-menakakota's avatar
    v-menakakota
    Community Support
    10 months ago

    Hi MathFR ,

    I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

     

    Best Regards, 
    Community Support Team.