We've already got the option to create an SQL project for Fabric warehouse, but wouldn't it be good if you were able to manage and develop your whole Fabric solution in a Visual Studio solution with appropriate projects?
My dream (bear in mind, I'm coming at this from a data engineer point of view) would be a single Visual Studio solution which I could have individual projects for data factory pipelines, warehouses, lakehouses, notebooks, eventhouses, semantic models and even PowerBI visuals. Then I could use CI/CD pipelines to deploy it all (well, I can dream can't I?)
This would really help with source control and deployment since currently we've got a mismash of deploying different artifacts using different methods, its a mess. Let us just be able to deploy 'professionally' using tools like Azure DevOps that we've been using for everything else?
It's obviously quite a bit of a thing to change/implement, but I think it would really help unify development for teams using familiar existing tools and not have to work on different things in different places (e.g. web portal, VS code, etc...). At the moment I'm constantly flicking between the web portal, VS code (when the darn Fabric extension works that is!) and various different deployment tools.
Recent ideas
Allow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara2 hours agoNew MemberNew4Views0likes0CommentsSupport Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi6 hours agoRegular VisitorNew1.3KViews18likes2CommentsExpose Refresh Warnings and Informational Messages via Notifications and API
When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention. Please pro...Jashwanth_K8 hours agoMicrosoft EmployeeNew23Views6likes0CommentsInvoke Pipeline Task - Workspace Identity Authentication
Currently, the Fabric Data Factory Invoke Pipeline task uses the user's credentials who saved the pipeline to then authenticate to the Azure Data Factory to execute the ADF pipeline. When that user'...dzebrowitz13 hours agoAdvocate IPlanned1.8KViews61likes5CommentsFabric Pipeline should run as workspace identity
Currently, Microsoft Fabric pipelines run under the identity of the last user who modified them, which can cause disruptions when tenant administrators make changes to security policies, such as enab...pellitteris13 hours agoAdvocate IINew1.4KViews27likes3Comments