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 for reaching out to the Microsoft fabric community forum. 

 

I would also take a moment to thank Ahmed-Elfeel    , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
I hope the above 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  

AMD0791's avatar
AMD0791
Advocate IV
10 months ago

Could you please provide an official Microsoft source for prior versions of Power BI Desktop? 

 

This is still an issue for our users.  Manually editing the DAX for the calculated table is a work-around, not a solution.  It's tedious and risks introducing error if it has to be done for each refresh.   When clicking "Refresh" in the ribbon, the calculated tables don't even appear in the dialog box showing the progress of the refresh.  I've even tried adding a calculated column with the current datetime -- this column updates, but the rest of the data does not, and the timestamp on the hover-over metadata does not update.

 

I'm not sure if even reverting to a previous version of desktop will address the problem -- it's often not possible to open files in an older version once they've been saved in a new version.