Visual not loading in service but in desktop: Microsoft.Data.Mashup.ErrorCode = 10704

I am encountering the same issue. The measure used in the visual, which includes simple calculations like subtraction and division, is generating an error. Is there something worked for you?

I’m encountering the same issue. The strange part is that the visualization works fine when I apply a filter (I have a month filter), but the problem arises when I select specific months. This report was working perfectly before, and it uses DirectQuery.

We are running into an identical issue as well. On ~Friday, any Power BI reporting that is not the file hosted on my desktop where I built out our team's semantic model is not loading, with the same error cited in this thread. This extends to 1) all reports accessed via the Power BI service, 2) all reports downloaded off of the service onto someone else's desktop, and 3) all other reports on my desktop Power BI that are built off of the main report's semantic model. In order to disseminate data to the business, I've been exporitng my desktop Power BI output as a PDF and disseminating it to the organization - definitely a suboptimal interim solution.

Has anyone figured out a solution here? We spoke with Microsoft support and they recommended query re-building, which would be unfeasible given the extent of our buildout. More importantly, though, given that everything was working perfectly just a few days ago and this error appears to have affected multiple organizations, this feels like a Microsoft internal issue.

same issues happening and started today out of nothing, reports that have been runing without issues for months .

Error fetching data for this visual

Expression.Error: We couldn't fold the expression to the data source. Please try a simpler expression.. Microsoft.Data.Mashup.ErrorCode = 10704. ;We couldn't fold the expression to the data source. Please try a simpler expression.. The exception was raised by the IDbCommand interface.
Please try again later or contact support. If you contact support, please provide these details.

Hi 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... 

It seems the issue has disappeared from the dashboard I'm working on. Has anyone else noticed this on their dashboards?

I am seeing the exact same thing, a report that has been working for months (in mixed mode)--> now the direct query part is failing without any reason. When the semantic model is opened in the desktop it works but not in the service. No changes to the code, no changes in the source (sharepoint list), 4300 records stable as we have a process to delete those.  

I have been seeing the issue for a few days now and I am seeing it today too.

========

Expression.Error: We couldn't fold the expression to the data source. Please try a simpler expression.. Microsoft.Data.Mashup.ErrorCode = 10704. ;We couldn't fold the expression to the data source. Please try a simpler expression.. The exception was raised by the IDbCommand interface.