Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
When I try to move some of the attributes to the visual, I get error Message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression...
I figured out that the issue is related to the number type attributes which may contain null values. Example:
Price
0.34
3.45
null
1.35
The "Price" attribute is a dimension to describe the invoice facts. If I put a step to replace null values by 0 then everything works fine. However, it's not a solution for me. I can change the data type to text and it will be fine as well, but again, it's a workaround instead of a solution.
Environment:
Did anyone have the same issue? Do you have solution for that?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.