Cannot visualize a field when in Direct Query fine if not

[symonreeves]

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 when trying to create a visual with only fields from the table (join disabled at this point and not needed)

When adding bigint field to the visual, produces error.

Below:

Feedback Type:
Frown (Error)

Timestamp:
2022-08-08T13:11:07.2865401Z

Local Time:
2022-08-08T13:11:07.2865401+00:00

Session ID:
d3d3c72f-253d-4406-bda6-72492c2b478e

Release:
July 2022

Product Version:
2.107.841.0 (22.07) (x64)

Error Message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
103 GB

Private Memory:
775 MB

Peak Working Set:
0.993 GB

IE Version:
11.789.19041.0

User ID:
42982a8d-d99b-45bc-bd53-f58fcfeb88e3

Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\pinnaca\Microsoft\Power BI Desktop Store App\FrownSnapShotab71e087-7481-47c2-a57b-e359c03abb45.zip

Model Default Mode:
DirectQuery

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\pinnaca\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_mobileAuthoringFormattingUI
PBI_sparklines

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared stores = let
Source = MariaDB.Contents("localhost:3306", "rdl_100"),
stores_Table = Source{[Name="stores",Kind="Table"]}[Data]
in
stores_Table;

[liyingjl]

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 I...
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

[symonreeves]

Thankyou

I have figured a workround

In my MariaDB table i changed BIGINT fields to INT then joins work as expected & the visuals also now always work fine.

Looks to be a bug when using BIGINT in Maria BD and using Direct Query only

[v-yingjl]

Glad to hear that this issue can be resolved by changing the data type and thanks for you sharing, it will help members on the community which may have the same issue, this issue will be closed.

Best Regards,
Community Support Team _ Yingjie Li