Workspace Access Controls
Give workspace admin(s) the ability to create custom roles for access to specific artifacts within the workspace and include the ability to control what each role has the ability to do within each artifact. For example, role 1 could have access to view warehouse & lakehouse but not edit them. ...
Write to custom schema in Dataflow Gen2
When setting a data destination, there should be functionality to allow the user to specify the schema that the results of the dataflow should write to when using a Warehouse or Lakehouse source.
Allow Copy Data activity in Data Factory to append records
Add functionality to allow the copy activity to append records to an existing destination.
Custom Folders for Queries
Allow for creation of custom folders within the "My queries" and "Shared queries" sections of the Warehouse. This will allow teams to organize their queries more appropriately vs utilizing namespace techniques.
Dataflow Gen2 Publish vs Run
Update/change functionality when publishing Dataflow Gen2. Currently, when a dataflow is published, the dataflow is saved and then automatically runs. Dataflow Gen1 functionality never did this. When authoring all I needed to do was save the dataflow and then it could be executed whenever. Hal...
Recover deleted workspace artifacts
Allow recovery of artifacts that have been deleted from a workspace; dataflows, pipelines, notebooks, etc.. Have a recycle bin per workspace for quick navigation & recovery.
Add reference/lookup functionality to Script Activity in Data Factory
Add in the ability for the user to lookup a saved query (via drop down) in the Script activity for Data Factory. The Script activity would output the results of the selected query. This would allow users to write SQL in one place instead directly inside the activity.
Explore creating new SQL focused offering as part of Data Factory Experience
Within the data factory experience we have Dataflows Gen2, an offering that offers low/no code programming for data transformations. What about the developers who prefer to work within a SQL environment for all of their transformations? Data warehouse allows for queries & views to be created b...
Option to turn off autosave on SQL Query
Give option to cut off autosave for SQL queries. Warehouse is constantly failing to autosave and throws error which results in ANOTHER query being created and lost work. Give toggle to cut on & off autosave. Also - stop auto-creating new queries for everything.
Alias field names
Allow users to create custom aliases in Power BI to fields in their model which are stored as part of the model (so that the alias is not specific to an individual report) and allow the user to overwrite a given alias inside of custom visual.
The process would look something ...