Walt Lillyman on 14 Oct 2021 12:48:30
As referenced in Microsoft support incident 2106290050002339, please add "Direct Query" capability to PowerBI when using the Snowflake-provided ODBC connector for Windows.
The reason for this request is that Direct Query, when using Microsoft's provided ODBC connector in PowerBI Desktop, issues a broad metadata request every time a query is refreshed, resulting in a significant delay when the Snowflake account contains many objects.
As described in Microsoft support incident 2106290050002339, that broad metadata request is NOT executed when using the Snowflake-provided ODBC connector for Windows.