symonreeves's avatar
symonreeves
Regular Visitor
4 years ago
Status:
Done

Cannot visualize a field when in Direct Query fine if not

  Hello 1. Trying to join 2 tables on a field with in Table A which is duplicated to Table B which has no nulls or dupliates. Only wants to join many to many which is incorrect. 2. The same table ...
Reports
Anonymous's avatar
Anonymous
Not applicable
4 years ago
The same table when trying to create a visual with only fields from the table (join disabled at this point and not needed)

Perhaps you can consider providing more details about it. If you have created some measures/columns by DAX formulas, it may cause this issue due to the DAX limitation.

See:

  1. Chris Webb's BI Blog: Understanding The “We Couldn’t Fold The Expression To The Data Source” Error In Power BI Chris Webb's BI Blog (crossjoin.co.uk)
  2. OLE DB or ODBC error: [Expression.Error] We couldn... - Microsoft Power BI Community
  3. Error: We couldn't fold the expression to the data... - Microsoft Power BI Community

 

Regards

Completed Ideas