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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

UDFs annotations Issue with Invoke-ProcessASDatabase

Hello power BI dev team,

I want to report that I recently discovered that if a UDF contains an annotation, this will make any request of the following kind to fail:

 

try {

Invoke-ProcessASDatabase -ServicePrincipal -DatabaseName "Function_Annotations" -RefreshType "Automatic" -Server "powerbi://api.powerbi.com/v1.0/myorg/workspaceName" -Credential $Cred -TenantID $Ten -ErrorAction Stop

}
catch {
    Write-Host "An error occurred. Displaying full exception details:" -ForegroundColor Red
    # The $_ variable in a catch block holds the error record
    Write-Output $_.Exception | Format-List * -Force
    # You can also inspect the full error record
    # Write-Output $_ | Format-List * -Force
} 

This is the error I get when the annotation is there:

ricardo_ona_0-1762172372565.png

If I remove the annotation, it runs with no issues:

ricardo_ona_1-1762172389859.png

I created a sample file I could share where you can replicate the issue (I was not able to attach it already).

Thanks for having a look at the issue!

 

Best,

Ricardo

 

Status: New
Comments
mh512
Microsoft Employee

Thanks for the feedback. At this point, the Analysis Services client library which ships in the Powershell module is outdated, so we will try to get that updated first.

ricardo_ona
Frequent Visitor
Thank you! @mh512