Forum Discussion
Error fetching data for this visual - Large Table Visual
Hello, I'm working on a project that I am encountering some errors and was wondering if there is anything I can do to improve my report via changing the model, etc. Here are the error message...
Once data is imported to the semantic model it is rarely an issue. Your problems are most likely the "live" (actually Direct Query) connection to the other semantic model.
- Check the cardinality of the join columns between your import mode tables and the tables of the other semantic model. Anything over 50 K will lead to very bad performance
- Familiarize yourself with DAX Studio, and learn about the Storage Engine, Formula Engine, Query Plan and Server timings. DAX Studio can help you to evaluate and refactor your measures for best performance and reduced resource requirements.