Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.