search

maikvandergaag / msft-extensions

Repository for extensions mainly used for Azure DevOps Extensions
https://msftplayground.com
MIT License
125 stars 81 forks source link

DeployTabularModel action not working #482

Closed erikvangijzen closed 1 year ago

erikvangijzen commented 1 year ago

I try to deploy a tabular model file (model.bim) to a power bi Workspace through a yaml pipeline. Everything runs fine without errors, however, in the end nothing is deployed to the Workspace. What is going wrong, is this a bug? With the publish action i can publish a pbix file without problems so the service endpoint is fine.

This is the code:

erikvangijzen commented 1 year ago

Ok, i managed to get it working

maikvandergaag commented 1 year ago

@erikvangijzen: sorry for the late response. What was the fix for you?

erikvangijzen commented 1 year ago

Hi Maik,

I added the connection string to the TabularEditorArguments. I used variables for all the variables😊 and I read the appkey from an azure keyvault:

TabularEditorArguments: '-D "Provider=MSOLAP;Data Source=powerbi://api.powerbi.com/v1.0/myorg/${{ variables.pbi_workspaceName }};User ID=app:${{ parameters.pbi_AppId }}@${{ parameters.tenantId }};Password=$(PowerBiAppKey);" "${{ parameters.modelname }}" -O -C -P -V -E'

I had quite a struggle to find out how this works, because there is no good documentation on this. I was also confused because i had to define the connection info again in the TabularEditorArguments, but it is also defined in the PowerBiServiceEndpoint.

Vriendelijke groet, Erik van Gijzen

From: Maik van der Gaag @.> Sent: donderdag 20 april 2023 08:43 To: maikvandergaag/msft-extensions @.> Cc: Erik van Gijzen @.>; Mention @.> Subject: Re: [maikvandergaag/msft-extensions] DeployTabularModel action not working (Issue #482)

@erikvangijzenhttps://github.com/erikvangijzen: sorry for the late response. What was the fix for you?

— Reply to this email directly, view it on GitHubhttps://github.com/maikvandergaag/msft-extensions/issues/482#issuecomment-1515792833, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A3JPMSTHH3IVCI7ECOUVRNLXCDLFZANCNFSM6AAAAAAXCMWRC4. You are receiving this because you were mentioned.Message ID: @.***>