Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

0

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;

Status: Delivered

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

Comments
liyingjl
Regular Visitor
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
Regular Visitor

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
Community Support
Status changed to: Delivered

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