Fantmas
6 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 SNC Authentication for SAP BW in Power BI Report Server
Organizations are increasingly moving toward encrypted and certificate-based authentication for SAP BW connections due to security and compliance requirements. Currently, Power BI Report Server (PBI...Indramouli2 days agoNew MemberNew7Views0likes0CommentsHow to remind the Global team to respond to ECNs with greater efficiency
Suggest Power BI send emails to each responsible person, and display how many days they have spent handling each ECN, compared to the required number of calendar days for completion.richardzhu2 days agoNew MemberNew38Views5likes2Comments