Forum Discussion
Direct Query + Snowflake resulting in queries with cast as date for every unique date
When generating reports using DirectQuery with a Snowflake Connector, I am encountering badly transposed queries in Snowflake for queries where the data is filtered on a Date or Date/Time range. The ...
Sorry I misunderstood how to apply the Value.NativeQuery. Here is how I managed to bypass this error :
= Value.NativeQuery(Snowflake.Databases("XXXX","WH_XXXX"){[Name="DB_XXXX"]}[Data], "SELECT * FROM ""SCHEMA_XXXX"".""MYTABLE""", null, [EnableFolding=true])
However, the problem persists, the queries sent to snowflake still have the "cast as date"... Do you know how to control the queries that are created and sent to Snowflake from DAX calculated measures?
See if you can use dynamic M Query parameters.
Chris Webb's BI Blog: Using Power BI Dynamic M Parameters In DAX Queries (crossjoin.co.uk)
Passing Any Arbitrary Value From A Power BI Report To A Dynamic M Parameter (crossjoin.co.uk)