+1
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?
Best answer by Christian Hauggaard
View original
+1
The use of partitions with XMLA endpoints it’s explain here:
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla
+5
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
+1
Yes
+5
+1
Yes, it would be nice:
+1
More detail:
+2
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 🙄
+1
Thanks
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
