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
Allow dynamic content in Activity Name (and other fields on general tab)
We copy a large number of tables by iterating through a ForEach activity and calling the copy activity for each. When trying to answer "which tables take a long time to copy", it's hard because all...Scott_Powell13 hours agoNew MemberNeeds Votes3.6KViews18likes3CommentsPower BI REST + PowerShell parity without Tenant Admin
Summary Item‑level APIs/cmdlets so engineers can automate what the UI can do without requiring Tenant Admin scopes. Problem Key actions (e.g., sensitivity labels) are admin‑only via REST; other...wbc_gr3 hours agoNew MemberNew190Views5likes1CommentRLS mismatch when assigning multiple regions in semantic model live connection.
Hello Community, I am facing an issue with Row-Level Security (RLS) in a Power BI report connected to a semantic model (live connection). I created RLS roles based on region-wise access. When I as...Arigela96401 day agoNew MemberNew3Views0likes0Comments