Connector SnowflakeDB

[hakals]

When using direct query against SnowflageDB there is problem with character set. The connector doesnt handle our specific characters Å,Ä,Ö in Slicers and Reports. If the dataset doesnt include these characters everything works fine

[hakals]

[v-qiuyu-msft]

Hi @hakals,

1. Does the issue occur when you use Import mode instead of DirectQuery?
2. Would you please translate the error message in English? Please share desktop trace log with us.
3. Please try to update the Power BI desktop to the latest version 2.56.5023.942 then try again in DirectQuery.

Best Regards,
Qiuyun Yu 

[hakals]

Hi @Vicky_Song, @v-qiuyu-msft!

Thanks for quick respons.

1. Does the issue occur when you use Import mode instead of DirectQuery? No problems with Import mode.
2. Would you please translate the error message in English? Please share desktop trace log with us.

Feedback Type:
Frown (Error)

Timestamp:
2018-03-15T08:29:22.4859175Z

Local Time:
2018-03-15T09:29:22.4859175+01:00

Session ID:
11b6fdbe-b4d7-49fc-93cc-6b6eda27a4b3

Release:
March 2018

Product Version:
2.56.5023.942 (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.16299.0 (x64 sv-SE)

CLR Version:
4.7 or later [Release Number = 461308]

Peak Virtual Memory:
34.1 GB

Private Memory:
328 MB

Peak Working Set:
470 MB

IE Version:
11.125.16299.0

User ID:
f3a711a4-69bf-47bc-83d5-e46542493ef4

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\hakals\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1973873275.zip

Performance Trace Logs:
C:\Users\hakals\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
200%

Supported Services:
Power BI

Formulas:

section Section1;

shared PBI_VIEW = let
    Källa = Snowflake.Databases("xxx", "ANALYTICS", []),
    CUSTOMER_DB_Database = Källa{[Name="CUSTOMER_DB",Kind="Database"]}[Data],
    CUSTOMER_Schema = CUSTOMER_DB_Database{[Name="CUSTOMER",Kind="Schema"]}[Data],
    PBI_VIEW_View = CUSTOMER_Schema{[Name="PBI_VIEW",Kind="View"]}[Data],
    #"Ersatt värde" = Table.ReplaceValue(PBI_VIEW_View,"Novth","November",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde1" = Table.ReplaceValue(#"Ersatt värde","Aprth","April",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde2" = Table.ReplaceValue(#"Ersatt värde1","Febth","Februari",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde3" = Table.ReplaceValue(#"Ersatt värde2","Marth","Mars",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde4" = Table.ReplaceValue(#"Ersatt värde3","Decth","December",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde5" = Table.ReplaceValue(#"Ersatt värde4","Julth","Juli",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde6" = Table.ReplaceValue(#"Ersatt värde5","Janth","Januari",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde7" = Table.ReplaceValue(#"Ersatt värde6","Mayth","Maj",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde8" = Table.ReplaceValue(#"Ersatt värde7","Octth","Oktober",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde9" = Table.ReplaceValue(#"Ersatt värde8","Augth","Augusti",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde10" = Table.ReplaceValue(#"Ersatt värde9","Septh","September",Replacer.ReplaceText,{"MonthNm"}),
    #"Ersatt värde11" = Table.ReplaceValue(#"Ersatt värde10","Junth","Juni",Replacer.ReplaceText,{"MonthNm"}),
in
    #"Ersatt värde15";

shared MASTER_CUSTOMER = let
    Källa = Snowflake.Databases("xxx", "ANALYTICS", []),
    CUSTOMER_DB_Database = Källa{[Name="CUSTOMER_DB",Kind="Database"]}[Data],
    CUSTOMER_Schema = CUSTOMER_DB_Database{[Name="CUSTOMER",Kind="Schema"]}[Data],
    MASTER_CUSTOMER_Table = CUSTOMER_Schema{[Name="MASTER_CUSTOMER",Kind="Table"]}[Data]
in
    MASTER_CUSTOMER_Table;

3. Please try to update the Power BI desktop to the latest version 2.56.5023.942 then try again in

DirectQuery

Still the same problem. 

[hakals]

@Vicky_Song, @v-qiuyu-msft!

Still no progress in this problem?

[hakals]

Could I get the case number. Snowflake developers wants to take a deeper look into this!

[hakals]

?

[AnGanjam]

Hi hakals

We looked into this issue and found that Snowflake driver doesn’t support WCHAR in our calls to check for Unicode capabilities (SqlGetTypeInfo). Snowflake only supports VARCHAR and not WVARCHAR, so we think we cannot send umlaut strings in query directly to Snowflake. Therfore any queries which use umlaut characters fail direct query. 

Thanks

Ananth [MS]