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-msft2 hours agoMicrosoft EmployeeNew8Views0likes0CommentsNative Multi-Visual Cascading Selection (Beyond Ctrl + Click)
The Problem: When working with multiple tables or matrices on a report page, users frequently need to chain selections together (e.g., clicking Matrix A filters Matrix B, and then clicking Matrix B ...7407546 hours agoNew MemberNew12Views0likes1CommentPipeline 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...ToddChitt6 hours agoSuper UserNew569Views7likes5CommentsAbout "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf6 hours agoFrequent VisitorNew30Views1like1CommentSupport 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...ryomaru08257 hours agoAdvocate INew9Views0likes0Comments