Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

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 in this case could be advanced, since "subscription viws" should be created for each entity, which we want to use in PowerQuery, and it should be refreshed every time the schema of a table changes.
Status: Needs Votes
Comments
olaf_nimz
New Member
I am sure you do know, that you are able to consume usual interface of MDS i.e. the subscribtion tables/views found in MDS database on the SQL Server.
pedro_coelho
New Member
Master data management is crucial to provide a more tailored analytics service to power users and azure needs it ! Would be a big plus for Microsoft data & analytics ecosystem.
fbcideas_migusr
New Member
Status changed to: Needs Votes