Reply
SivaMani
Resident Rockstar
Resident Rockstar

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 programmatically?

 

A little background: The table is structured with attributes and their values, which must be pivoted based on the requirement.

TypeValue
ID1
TitleText
Date

2024-09-04

 

IDTitleDate
1Text2024-09-04

 

I need to ensure that any new attributes added to the data source are included as new columns in the model without having to refresh it on the desktop and publish it every time.

Example,

TypeValue 
ID1 
TitleText 
Date

2024-09-04

 
Is Completedyes

yes

Completed Date

2024-09-06

 
1 ACCEPTED SOLUTION

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

View solution in original post

11 REPLIES 11
aj1973
Community Champion
Community Champion

Hi @SivaMani 

  • Use dynamic data sources in Power BI. This involves setting up your data source query to dynamically adapt to changes in the schema. For example, using SQL queries that select all columns (SELECT *) can help ensure new columns are automatically included.
  • In Power Query, avoid hardcoding column names. Instead, use functions like Table.ColumnNames to dynamically reference columns.
  • Set up data alerts and monitoring to notify you when new columns are added to the data source. This can help you stay informed and take necessary actions if needed.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

As a side note - Power Query HATES data source changes. It will punish you with endless "Evaluating..."  dialogues that you can either sit out or cancel (which will make it worse).  So think twice before you go that route.

SaiTejaTalasila
Super User
Super User

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 

 

 

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

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.

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

@lbendlin Is there any documentation/blog on using ALM Toolkit for my use case?

Hi @SivaMani ,

 

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

 

Thanks,

Sai Teja 

lbendlin
Super User
Super User

Use ALM Toolkit.

@lbendlin Let me give it a try. Thanks!

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)