PowerQuery: Ability to save the result to MSSQL Database
If a user with proper rights could load the result of a query in PowerQuery to database as a new table, and could schedule it's refresh, the functionality could open up many new self-service scenarios on department level.
STATUS
DETAILS
New
MDS (MSSQL Master Data Services) as a data source
MDS can be a key player in self-service scenarios, since it can provide a managed way to create and maintain parameter tables, mappings, hierarchies for separate data mart dimensions in a self-service way for even business users. In SQL16 it will get a refresh, and maybe the integration story ...
STATUS
DETAILS
New