Skip to main content
Microsoft Idea

Power BI

New

Add SQL as an Option in Load Data in SQL notebooks

Vote (1) Share
Mike Carlo's profile image

Mike Carlo on 10 Apr 2024 16:24:35

When Inside a SQL enabled Notebook, I'd like a Load using SQL shortcut from the Lakehouse.


It would be really nice to have an additional shortcut to load a table or select top 100 from a Lakehouse when in the default notebook of SQL.


Today when you right click on a table inside a notebook from the the Lakehouse you can see a menu with Load Data. The only option is currently Spark in the menu.


I'd like to add a new option for SQL in this list.


Today you can Drag a table from the Lakehouse to a Cell in the notebook and get a simple "Select * From Limit 100" statement. I'd also like this feature in the Load Data menu.