Visual throws query folding issue in report but works fine in corresponding Power BI dataset

[Anonymous]

I am getting below issue

This error is only coming up in PBI report. If I copy the same visual in the PBI dataset of that report then it works fine. data source is snowflake and connection is direct query. Any help is appreciated

[YalanWu_test]

Hi, @Anonymous ;

You can do some pretty complex things in the Power Query Editor and in DAX and the error message above is the error you get when Power BI admits defeat and says it can’t translate a DAX query generated by a visual on a report into a query against your data source. The cause is likely to be a combination of several of the of the following:

• A complex data model
• Complex DAX used in measures or calculated columns
• The use of dynamic M parameters
• Complex transformations created in the Power Query Editor

How can you avoid it? Again, I can only offer general advice:

• Don’t do any transformations in the Power Query Editor if you’re using DirectQuery mode. If you want to use DirectQuery you should always make sure your data is modelled appropriately in whatever data source you’re using before you start designing your dataset in Power BI.
• Keep your data model as simple as possible. For example, avoiding bi-directional relationships is a good idea.
• Try to implement as much of the logic for your calculations in your data source and reduce the amount of DAX you need to write.
• Try to write your DAX in a different way in the hope that Power BI will be able to fold it.

https://blog.crossjoin.co.uk/2022/05/08/understanding-the-we-couldnt-fold-the-expression-to-the-data-source-error-in-power-bi/

Best Regards,