Forum Discussion
Helper ICouldn't load the data for this visual.
Hello there,
I am getting "Couldn't load the data for this visual. OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression." error. My data source is a snowflake database and my connection is a direct querry. I created a simple calculated column by using DATEDIFF. I researched and got some articles talking about querry folding but can't find for snowflake and direct querry. Can somebody help me please?
Kira_Net , Try int([End Date] -[Start Date])
also check
https://www.youtube.com/watch?v=8hjdOCni_ZY
https://docs.microsoft.com/en-us/power-query/power-query-folding
2 Replies
- amitchandak
Super User
Kira_Net , Try int([End Date] -[Start Date])
also check
https://www.youtube.com/watch?v=8hjdOCni_ZY
https://docs.microsoft.com/en-us/power-query/power-query-folding
Hi Kira_Net ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
