Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Has anyone noticed that the ability to specify a native SQL query has been removed from the "Advanced Options" section of the Snowflake connector? I've also noticed that I am unable to bring up the Native SQL query window in EXISTING reports that have snowflake Native SQL queries, but they still work (I just can't edit them) any longer. Editing is possible in Advanced Editor, however, all the line feed/break, and tab characters make it difficult to work with.
Was this an oversight? Documentation on Snowflake connector says Native Queries are supported, but what about the UI part of the equation.... anyone?
This is what my December 2023 PowerBI Get Data (PowerQuery) screen looks like now...
Databases that support Native Query in PowerQuery...
Import data from a database using native database query - Power Query | Microsoft Learn
I was looking for answers to this exact issue - I can see SQL statement field in Power BI Desktop, but not on Server - hope that helps.
Can you scroll down? I see this with Snowflake. December build.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
39 | |
21 | |
20 | |
13 | |
13 |