Forum Discussion

SivaMani's avatar
SivaMani
Resident Rockstar
1 year ago
Solved

Refresh Power BI Metadata

Hello,   I have a situation where I need to add new attributes to the Power BI Semantic Model (published to Service). Is there a way to refresh the metadata of a semantic model using an API or prog...
General Comment
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    1 year ago

    That's what ALM Toolkit does.  Or you can go rogue and craft your own XMLA.

SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
1 year ago

Hi SivaMani ,

 

I think pivot will be able to handle it.Can you check once -

PivotedTable = Table.Pivot(RemoveDuplicates, List.Distinct(RemoveDuplicates[Type]), "Type", "Value")

 

Thanks,

Sai Teja 

 

 

  • SivaMani's avatar
    SivaMani
    Resident Rockstar
    1 year ago

    SaiTejaTalasila This only works on Desktop. Thanks for your response!

    • SaiTejaTalasila's avatar
      SaiTejaTalasila
      Super User
      1 year ago

      Hi SivaMani ,

       

      If it is working on desktop then it will work on service.

       

      Thanks,

      Sai Teja 

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      1 year ago

      I believe It may not work. As Power BI Service only refreshes the source's data. However, Power BI desktop does data and schema refreshes.

       

      I am looking for a way to refresh the schema of the semantic model published to Service, either through a tool or programmatically.

      • lbendlin's avatar
        lbendlin
        Super User
        1 year ago

        That's what ALM Toolkit does.  Or you can go rogue and craft your own XMLA.