Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
AnthonyGenovese
Resolver III
Resolver III

Any way to trigger an XMLA PBI Refresh operation?

I have a set of XMLA scripts that refresh some PBI models. (Specific table orders, not loading dimensions that don't change, partitions, etc. We don't want to just refresh the entire dataset.) Is it possible to have a data pipeline connect to a PBI XMLA endpoint and execute the scripts?

5 REPLIES 5
AndySteinke
Frequent Visitor

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=4bfc0f26-6b3b-ee11-a81c-000d3a7bf537

 

Solid idea, I added it.  We ended up using Powershell to do the refreshes (or logic apps) but having a nice easy connector would be great.

GraceGu
Microsoft Employee
Microsoft Employee

There is no native activity supporting this. 

Data pipeilne will soon have native dataset refresh activity, but seems this does not help your case. 

It will be great if you can submit an idea to help prioritization of this need. Thank you!

DennesTorres
Impactful Individual
Impactful Individual

Hi,

I know this is not exactly the question, but I hope it helps.

Before Microsoft Fabric, I wrote an article about automating table refreshes in Power BI using Azure Automation. This is the link: https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/how-to-automate-table-level-...

I don't think Data Factory has any connector available for the XMLA endpoint, but you can use alternation options like this one.

Kind Regards,

Dennes

Thanks. We will keep this in mind. We do need to stick with what we already have access to, because our IS department moves so slow in giving us access to other Azure items. 

Hi

This will require some investigation, but I hope I can guide you on the right path:

This link has more links with explanation about how to do this with data factory, using Power BI API's to trigger the refresh. In this case, instead of XMLA, it would be with Power BI API calls: https://data-marc.com/2021/10/28/automate-power-bi-single-table-refresh-using-azure-data-factory-and...

Another possibility to stick to XMLA would be to create a custom activity for data factory. These links below may give you some direction:

https://techcommunity.microsoft.com/t5/fasttrack-for-azure/developing-custom-activities-in-data-fact...

https://learn.microsoft.com/en-us/azure/data-factory/transform-data-using-custom-activity 

Kind Regards,

Dennes

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!