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 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;