Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm having problems using date/datetime fields when connecting to Snowflake with direct query.
Dragging any date/datetime column into a visual or using it as a filter will result in this error:
I haven't made any calculations, table relationships or anything to the dataset, the column is exactly as it is in the database.
I also tested adding an empty calculated column in Power BI Desktop and changing the type to datetime. That column will give the same error.
Here's an extract of the trace logs:
(12.4.2018 13.43.49) Message: The resource file 'msmdsrvi.rll' for locale '1035' could not be loaded. Switching to US English (1033) if available. (Source: \\?\C:\Users\*****\AppData\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace405029051\Data\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019) (4/12/2018 1:44:25 PM) Message: OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)). (Source: \\?\C:\Users\*****\AppData\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace405029051\Data\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003) (4/12/2018 1:44:41 PM) Message: OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.. (Source: \\?\C:\Users\*****\AppData\Local\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces\AnalysisServicesWorkspace405029051\Data\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210003)
Changing the locale to US English did not help.
I haven't had any similar problems with import datasets in the same environment.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.