Hi,
I connected to my BigQuery DB by bigquery connector. BD data in English and Russian. When i'm trying to filter my view by one column (using slicer or page level filter) and choose some data in Russian, I get the error "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..". Everything is ok with data in Enlgish.
I think there may be some troubles with UNICODE and cp1251 encoding.
Help plz
Full error details:
Feedback Type:
Frown (Error)
Timestamp:
2018-05-04T16:43:27.0434402Z
Local Time:
2018-05-04T19:43:27.0434402+03:00
Session ID:
182e48b7-6565-41b7-8b59-eeb14e08ddb6
Release:
April 2018
Product Version:
2.57.5068.721 (PBIDesktop) (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.14393.0 (x64 ru-RU)
CLR Version:
4.7 or later [Release Number = 460805]
Peak Virtual Memory:
34.3 GB
Private Memory:
584 MB
Peak Working Set:
671 MB
IE Version:
11.2125.14393.0
User ID:
6ca36cb9-c8ea-451e-984b-aea20a4e6ad0
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
DirectQuery
Snapshot Trace Logs:
C:\Users\a.alaverdyan\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot30116487.zip
Performance Trace Logs:
C:\Users\a.alaverdyan\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_qnaExplore
PBI_variationUIChange
PBI_canvasTooltips
Enabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
150%
Supported Services:
Power BI
Formulas:
section Section1;
shared AttrAdCost_Aggr_test = let
Source = GoogleBigQuery.Database(null),
#"zilart-181807" = Source{[Name="zilart-181807"]}[Data],
Test_db_Schema = #"zilart-181807"{[Name="Test_db",Kind="Schema"]}[Data],
AttrAdCost_Aggr_test_Table = Test_db_Schema{[Name="AttrAdCost_Aggr_test",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(AttrAdCost_Aggr_test_Table,{{"attributed_adSourceGroup", type text}})
in
#"Changed Type" ;
