Skip to main content

    Power BI

    Needs Votes

    MDS (MSSQL Master Data Services) as a data source

    Vote (45) Share
    's profile image

    on 15 Oct 2015 02:11:26

    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.

    Comments (2)
    's profile image Profile Picture

    Pedro Coelho Silva on 05 Jul 2020 23:53:11

    RE: MDS (MSSQL Master Data Services) as a data source

    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.

    's profile image Profile Picture

    OlafTrivadis on 05 Jul 2020 23:38:54

    RE: MDS (MSSQL Master Data Services) as a data source

    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.