Error: We couldn't fold the expression to the data source. Please try a simpler expression

[Anonymous]

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]

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.

[Anonymous]

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!