Forum Discussion

navarroj's avatar
navarroj
New Member
7 years ago
Solved

Import Power BI Metadata

Hi There,
We have an excel file with information about tables/columns descriptions. We want to populate them into the model  itself.
Any sugestions on how to do that?

  • There is no way to do this in Power BI Desktop at present. There are no APIs available which allow for editing the model metadata.

     

    When the read/write XMLA endpoint is released on PowerBI.com you will be able to do this on Premium capacties on PowerBI.com, but it's not clear yet whether models edited in such a way can then be opened in Desktop after they've been modified. 

2 Replies

  • There is no way to do this in Power BI Desktop at present. There are no APIs available which allow for editing the model metadata.

     

    When the read/write XMLA endpoint is released on PowerBI.com you will be able to do this on Premium capacties on PowerBI.com, but it's not clear yet whether models edited in such a way can then be opened in Desktop after they've been modified. 

  • if we want to import meta data we have to click transform & load option then it will work

    meta data is nothing but data over the data this will be done at power query editor