Forum Discussion
Direct Query + Snowflake resulting in queries with cast as date for every unique date
You need to run your native query against the database, not the table.
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)