Forum Discussion
Visual not loading in service but in desktop: Microsoft.Data.Mashup.ErrorCode = 10704
We did not do anything. It was fixed by Microsoft since it was a bug with a new release?
Super UserHi Anonymous ,
To better understand the error message, use ChatGPT 🙂 Anyway, the problem, simply stated is that the visual is overloaded by the fields/measures or in direct quer it may be by the queries. It cant handle it with the resources it has in the service, while locally (in desktop) it can. It is possible, that you e.g. have locally more RAM and therefore in desktop it works, but in online it fails.
Try to optimize the query or measures used or filter out some data...
Thanks for your response, but I have another concerns as well that these reports have been running w/o any error for the past 5 month, so what could be the possible reason behind this sudden failure.
- zenisekd
If the data is incrementally growing, maybe it just made the breakeven point...
Yes, but that was already been taken care of at the source itself, but thanks a lot for your response
Hi Anonymous ,
Thanks for reaching out to the Microsoft fabric community forum.
As your error message indicates the query is not folding,
-> Please check in Power BI if the data types in columns are correct and haven’t been changed accidentally which resulted in a mismatch with source datatype.
-> Keep your data model as simple as possible. For example, avoiding bi-directional relationships is a good idea.
-> Try to write your DAX in a different way in the hope that Power BI will be able to fold it.
-> Check if the custom query has any syntax errors in it.If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards
no the amout of data is not the reason - we do have various ammounts per semantic model and all share same problem.