Forum Discussion
F5-Evan
2 years agoNew Member
Too many literal binary expressions in the query. The maximum number is 200
I have a Power BI report grabbing data from dataverse and have found a few of my visuals returning the error above: "Too many literal binary expressions in the query. The maximum number is 200" th...
matthiashh
Advocate I
2 years agoSame issue. I also have a composite model due to the fact that this is a demo for integrated interactive commenting. It has an integrated PowerApp to enter comments that are stored in a DataVerse table and should occur in a timely manner.
That worked fine until at least 2 months ago.
I didn't accessed the demo since then and I did not changed any of it nor of the components it depends on. It was just not used in the meantime.
So this error message should be caused by changes in the platform.
The same error occurs when opening the pbix file locally with Power BI desktop.