Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 Reporting