Fantmas
7 months agoHelper III
Status:
New
Excel connector for Fabric SQL databases without Server/Database (workspace picker + SSO)
Hi SQL Community,
Today in Excel (Power Query), connecting to a Fabric SQL database/endpoint requires manually entering Server and (often) Database. Even when SSO (Entra ID) works, users still need to copy/paste connection strings.
Idea: Add a Fabric-native connector (or enhance the existing one) that lets users browse Fabric workspaces and select a SQL database / Warehouse / SQL endpoint directly (similar to “From Power BI”), with SSO and no manual Server/Database fields.
This would improve usability, reduce errors, and make self-service analytics easier for business users.
Is this on the roadmap? Any recommended best practice in the meantime?
No CommentsBe the first to comment
Recent ideas
Support Git-Integrated Files in Fabric Workspaces
Overview Allow users to store and manage arbitrary files such as .md, .sql, .py, and .yml directly in a Fabric workspace, with built-in Git integration. Value This would keep documentation, SQL sc...ryomaru08251 hour agoAdvocate INew26Views4likes1CommentConsistent Locale Handling Across Power BI, Fabric, PowerPoint, and Subscriptions
Microsoft Fabric and Power BI should provide consistent locale handling across all user experiences. Today, locales such as German (Switzerland) are correctly respected in Power BI Desktop and the Po...Le_M2 hours agoRegular VisitorNew14Views1like0CommentsIn Data Pipelines, Schedules should not be part of the definition
The request is to ensure Schedules are not included in the definition of a Data Pipeline for purposes of Deployment Pipelines. Today, when we deploy content across environments, the item frequent...schneiw3 hours agoAdvocate IVUnder Review812Views25likes3CommentsPipeline activity Refresh SQL Endpoint (preview) does not accept dynamic content
I am testing out the new Pipeline activity for Refresh SQL Endpoint, currently in preview. Sure, I get it that this is in preview, but it should at least have basic minimum functionality. It do...ToddChitt3 hours agoSuper UserNew587Views8likes6CommentsPower BI Admin & Governance Center – Centralized Activity and Usage Analytics
Subject: Feature Proposal: Advanced Power BI Admin & Governance Center – Centralized Activity, Access, Sharing, Licensing and Usage Analytics Dear Microsoft Power BI Team, I would like to propose a...Dr7awb8 hours agoNew MemberNew5Views0likes0Comments