- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Type | Value |
ID | 1 |
Title | Text |
Date | 2024-09-04 |
ID | Title | Date |
1 | Text | 2024-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,
Type | Value | |
ID | 1 | |
Title | Text | |
Date | 2024-09-04 | |
Is Completed | yes | yes |
Completed Date | 2024-09-06 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's what ALM Toolkit does. Or you can go rogue and craft your own XMLA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's what ALM Toolkit does. Or you can go rogue and craft your own XMLA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@lbendlin Is there any documentation/blog on using ALM Toolkit for my use case?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use ALM Toolkit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-16-2024 01:44 PM | |||
08-16-2021 08:24 PM | |||
06-28-2024 10:13 AM | |||
01-02-2018 05:24 AM | |||
08-14-2024 01:18 AM |
User | Count |
---|---|
26 | |
24 | |
13 | |
10 | |
9 |
User | Count |
---|---|
50 | |
41 | |
24 | |
19 | |
16 |