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
:: operator for typecast in T-SQL
Introduce support for the ::type cast operator in Fabric Data Warehouse as syntactic sugar for the existing CAST(... AS type) expression. The new operator would be functionally equivalent and compile...jovanpop-msft3 minutes agoMicrosoft EmployeeNew46Views7likes2CommentsAllow calls of Fabric SQL Database stored procedures from Data Warehouse
It would be great if there were a possibility to call a SQL Database stored procedures directly from a Data Warehouse stored procedures. A use case for this would be e.g. logging activities and even...Vojtech_Dolejsi2 hours agoNew MemberUnder Review2.9KViews13likes2CommentsPower BI - Org apps and cross-report drillthrough
This idea is a request to provide cross-report drill-through capability for org apps. This means being able to navigate between reports hosted in different org apps. The following sections detail why...TomMartens3 hours agoSuper UserNew1.3KViews24likes3CommentsMatrix Visual Missing Horizontal Scrollbar When Using Multiple Row Fields
Hello Power BI Team, I would like to report what appears to be a limitation or usability issue with the Matrix visual. I am using a Matrix with a large number of fields placed in the Rows section (...MERTARSLAN644 hours agoNew MemberNew5Views0likes0Comments