Forum Discussion
Couldn't load data for this visual: The reference calculated table which does not hold any data
Hey everyone.
I use a calculation table to filter my model. from time to time I stand in front of an error message:
"
Couldn't load the data for this visual
The query referenced Calculation Group Table 'cgPeriods' which does not hold any data because it needs to be recalculated or refreshed. Technical Details:
"
I managed to resolve this by processing a recalculation in the database.
I'm curious why this issue occurred and how we can prevent it from happening again in the future.
thanks
Hi, guyko
You can avoid this problem in the following ways:
1. Recalculate or refresh. As you mentioned, handling the recalculation manually in the database solved the problem. This indicates that the calculation table needs to be updated. To prevent this from happening again, make sure the calculation sheet is set to refresh automatically. You can configure scheduled refreshes in the Power BI service to keep your data current.
2. Data modeling and relationships. Check the relationships between tables in the data model. Incorrect relationships or missing data can cause problems.
3. Data source connection. Verify that the data source connected to the calculated table is accessible and provides data. Sometimes, connection issues can cause calculation tables to be empty. Check the data source for any changes that might affect the table (such as schema modifications or access rights)
4.Power BI versions and updates. Keep your Power BI Desktop and Power BI services up to date. Sometimes problems are solved in new versions.
Remember that calculation tables are dynamic and their contents depend on the underlying data. Validate and refresh your data regularly to avoid encountering similar errors in the future.How to Get Your Question Answered Quickly
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- lbendlin
Super User
That is a known side effect of "Direct Query with local data model" connections. Only an issue for you (the developer), not for the report users.
Hi, guyko
You can avoid this problem in the following ways:
1. Recalculate or refresh. As you mentioned, handling the recalculation manually in the database solved the problem. This indicates that the calculation table needs to be updated. To prevent this from happening again, make sure the calculation sheet is set to refresh automatically. You can configure scheduled refreshes in the Power BI service to keep your data current.
2. Data modeling and relationships. Check the relationships between tables in the data model. Incorrect relationships or missing data can cause problems.
3. Data source connection. Verify that the data source connected to the calculated table is accessible and provides data. Sometimes, connection issues can cause calculation tables to be empty. Check the data source for any changes that might affect the table (such as schema modifications or access rights)
4.Power BI versions and updates. Keep your Power BI Desktop and Power BI services up to date. Sometimes problems are solved in new versions.
Remember that calculation tables are dynamic and their contents depend on the underlying data. Validate and refresh your data regularly to avoid encountering similar errors in the future.How to Get Your Question Answered Quickly
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
