Skip to main content

    Power BI

    New

    Automatically add field properties from preexisting data source meta data

    Vote (9) Share
    Martin Stickley's profile image

    Martin Stickley on 30 Oct 2018 15:18:05

    Provide a way of automatically pulling through, or a programmable way of adding, table/column meta data (descriptions and extended properties) from a SQL Server data source. I have already added meta data to my SQL server data source so it would be great if I could have these added without having to do it manually.

    Comments (3)
    Martin Stickley's profile image Profile Picture

    e6f9e561 b1cd-4d89-a863-a169bd68eae5 on 05 Jul 2020 23:59:03

    RE: Automatically add field properties from preexisting data source meta data

    In general, the ability to import view/table/column comments from the data source (any database and, why not, also dataflows) would be very helpful.

    Martin Stickley's profile image Profile Picture

    13fcaa28 69e3-4492-943b-50a9b50aeda9 on 05 Jul 2020 23:48:41

    RE: Automatically add field properties from preexisting data source meta data

    I'm surprised that this doesn't have more votes. It would be extremely useful to import extended properties from an SQL database.

    Martin Stickley's profile image Profile Picture

    1a5c6ebc f836-4e7f-b803-2dbfe49e7a30 on 05 Jul 2020 23:48:13

    RE: Automatically add field properties from preexisting data source meta data

    I'm in the same boat except using PostgreSQL over ODBC and would like the comments I've put in the column and table comment field to show up in power bi in the description field.