JamesBI
1 year agoRegular Visitor
Status:
New
Improve Error Message and Add Pre-Run Checks for Missing Lakehouse in Notebooks
When running Spark SQL in a Fabric notebook without a Lakehouse attached, the current error message is overly technical and not very helpful:
AnalysisException: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.)
This could be improved with a more user-friendly message, such as:
"It looks like your notebook isn't connected to a Lakehouse. Please attach one using the Lakehouse dropdown at the top of the notebook to use Spark SQL features."
Bonus Feature Request:
It would be incredibly helpful to have a pre-run validation feature, similar to Power Automate’s Flow Checker, that scans the notebook for common issues like:
- Missing Lakehouse attachment
- Invalid or missing table references
- Unsupported operations in the current context
This would help users catch issues before execution and improve the overall user experience.
No CommentsBe the first to comment
Recent ideas
Power Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes5 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v5 hours agoCommunity ChampionNeeds Votes36Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_6 hours agoNew MemberAbandoned25Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer7 hours agoAdvocate INew1.2KViews26likes2CommentsImprove relationship visualisation in Model View for large semantic models.
When working with complex models containing many fact and dimension tables, relationship lines frequently cross and overlap, making lineage difficult to follow. A useful enhancement would be to allo...jcheeseaos8 hours agoNew MemberNew12Views0likes0Comments