We couldn't fold the expression to the data source. - Snowflake connecter

[Bwsmith]

Feedback Type:
Frown (Error)

Timestamp:
2021-05-10T22:12:20.9777415Z

Local Time:
2021-05-10T12:12:20.9777415-10:00

Session ID:
65ecd7db-b180-4a0f-a281-cef9298ab2f3

Release:
April 2021

Product Version:
2.92.1067.0 (21.04) (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.18363.0 (x64 en-US)

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

Peak Virtual Memory:
38.2 GB

Private Memory:
610 MB

Peak Working Set:
846 MB

IE Version:
11.1411.18362.0

User ID:
10e4d51f-9fee-4010-bcab-cbefc71c2257

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

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\brent_smith\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot5f779f36-7f8a-4680-a245-71a9c3359730.zip

Model Default Mode:
DirectQuery

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_eimInformationProtectionForDesktop
PBI_newFieldList

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_cartesianMultiplesAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared DATA_PROVIDER = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    DATA_PROVIDER_View = INGESTION_Schema{[Name="DATA_PROVIDER",Kind="View"]}[Data]
in
    DATA_PROVIDER_View;

shared DATA_SOURCE_INFORMATION = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    DATA_SOURCE_INFORMATION_View = INGESTION_Schema{[Name="DATA_SOURCE_INFORMATION",Kind="View"]}[Data]
in
    DATA_SOURCE_INFORMATION_View;

shared JOB_STEP_STATUS = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    JOB_STEP_STATUS_View = INGESTION_Schema{[Name="JOB_STEP_STATUS",Kind="View"]}[Data]
in
    JOB_STEP_STATUS_View;

shared DATA_SOURCE = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    DATA_SOURCE_Table = INGESTION_Schema{[Name="DATA_SOURCE",Kind="Table"]}[Data]
in
    DATA_SOURCE_Table;

shared DATA_SOURCE_COLUMN = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    DATA_SOURCE_COLUMN_Table = INGESTION_Schema{[Name="DATA_SOURCE_COLUMN",Kind="Table"]}[Data]
in
    DATA_SOURCE_COLUMN_Table;

shared DATA_SOURCE_DEPENDENCY = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    DATA_SOURCE_DEPENDENCY_Table = INGESTION_Schema{[Name="DATA_SOURCE_DEPENDENCY",Kind="Table"]}[Data]
in
    DATA_SOURCE_DEPENDENCY_Table;

shared FILE_FORMAT = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    FILE_FORMAT_Table = INGESTION_Schema{[Name="FILE_FORMAT",Kind="Table"]}[Data]
in
    FILE_FORMAT_Table;

shared FILE_FORMAT_FIXED_WIDTH_FIELD = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    FILE_FORMAT_FIXED_WIDTH_FIELD_Table = INGESTION_Schema{[Name="FILE_FORMAT_FIXED_WIDTH_FIELD",Kind="Table"]}[Data]
in
    FILE_FORMAT_FIXED_WIDTH_FIELD_Table;

shared JOB = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    JOB_Table = INGESTION_Schema{[Name="JOB",Kind="Table"]}[Data]
in
    JOB_Table;

shared JOB_FILE = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    JOB_FILE_Table = INGESTION_Schema{[Name="JOB_FILE",Kind="Table"]}[Data]
in
    JOB_FILE_Table;

shared JOB_STATUS = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    JOB_STATUS_Table = INGESTION_Schema{[Name="JOB_STATUS",Kind="Table"]}[Data]
in
    JOB_STATUS_Table;

shared JOB_STATUS_DESCRIPTION = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    JOB_STATUS_DESCRIPTION_Table = INGESTION_Schema{[Name="JOB_STATUS_DESCRIPTION",Kind="Table"]}[Data]
in
    JOB_STATUS_DESCRIPTION_Table;

shared WORKFLOW_STEP = let
    Source = Snowflake.Databases("hawaiianair.west-us-2.azure.snowflakecomputing.com", "ACCESSADMIN_TEST", [Role="ENVIRONMENTADMIN_TEST", CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    ADMIN_TEST_Database = Source{[Name="ADMIN_TEST",Kind="Database"]}[Data],
    INGESTION_Schema = ADMIN_TEST_Database{[Name="INGESTION",Kind="Schema"]}[Data],
    WORKFLOW_STEP_Table = INGESTION_Schema{[Name="WORKFLOW_STEP",Kind="Table"]}[Data]
in
    WORKFLOW_STEP_Table;

[v-lili6-msft]

hi

try to update  Snowflake ODBC driver to latest version.

if you could use import in this pbix file.

Regards,

Lin

[Bwsmith]

I am currently using the Power BI snowflake connector. I need to use directquery for the report as I need the results to be “on demand”. - Import does work using the Power BI snowflake. -Using ODBC with snowflake does work. Neither provide the “on demand” functionality vital to the intended use of the report. BTW using Tableau to create the report does work. Brent

[v-lili6-msft]

hi

I don't have Snowflake on my side, please create a support ticket to let engineers look into the issue on your side. 

Regards,

Lin