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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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?

Frequent Visitor


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.

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!

Impactful Individual
Impactful Individual


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:

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,


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. 


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:

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

Kind Regards,


Helpful resources


Fabric Monthly Update - June 2024

Check out the June 2024 Fabric update to learn about new features.