Calculated table update

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