Forum Discussion
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...
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.
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.