Skip to main content

Until I have started using TX, I am setting up my PBI import datasets using incremental update as you can see in:

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Now, in TX, how can this be accomplished?

The use of partitions with XMLA endpoints it’s explain here:

 

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla


You should be able to process a partition using a PowerShell script similar to the below

$secpasswd = ConvertTo-SecureString "****" -AsPlainText -Force; `

$mycreds = New-Object System.Management.Automation.PSCredential ('user@email.com’, $secpasswd); `

Invoke-ProcessPartition -Server "powerbi://api.powerbi.com/v1.0/myorg/ChaugTest" -TableName "Currency" -Database "ChaugPBILaunch" -PartitionName "All Currency" -RefreshType "Full" -Credential $mycreds

 


Yes @Christian Hauggaard , but my question it’s to be able to define the incremental refresh inside of TX semantic model, perphaps in a future feature.


@rvgfox OK, please feel free to submit a feature request for this


Yes, it would be nice:

 

 


More detail:

 


@rvgfox OK, please feel free to submit a feature request for this

I have an email from our partner’s solutions specialist confirming that incremental loading of XMLA endpoints will be available in future releases. This email was sent in June 2021, so I hope this feature request is still somewhere on the list 🙄


Thanks @erik.van.mastrigt , this feature I think that must be mandatory because with TX, it generate import models in PBI, and if the data quantity it’s very big we need use the incremental load….


Reply