Error: We couldn't fold the expression to the data...

Anonymous · ‎11-10-2020

Hi,

I'm using the Microsoft CDQ Connector with PowerQuery and whenever I add measures I randomly get this error message:

I'm not using complex expressions... just filtering and basic operators.

This is starting to heavily affect my work. Is there a workaround that I can use? I'd rather not roll back to a previous version of Power BI. Any suggestion is welcome!

Thanks in advance!

edhans · ‎11-10-2020

It looks like you are using direct query. Can you use import mode? Direct Query has some limitations on what DAX you can do, and you are hitting quite a few of them.

See this article on Direct Query.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

Anonymous · ‎11-13-2020

Hi, Unfortunately I cannot use Import mode. I'm working on a large set of data.
I found that aggregators don't work well, so I'm pretty much going around it by counting and filtering.

I managed to recalculate most of what I need... still in the weeds for some of them, but I'm figuring it out!