topic Re: Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with P in Developer

Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with PowerShell

mbutler71 — Fri, 18 Jun 2021 19:56:02 GMT

I was working to implement true CI/CD between Azure DevOps and our Power BI service.

Had a lot of trouble updating the Dataset's (report) Datasource and having it automatically "Maps To" the correct Gateway Datasource (DSN).

So, here is the solution that worked:
The Service Principal has access to update the Dataset's datasouce, but doesn't have access to the Gateway datasource (interface doesn't allow it at this time). So, we use the Service Principal to update the datasource in one PowerShell script, and a Generic Id to refresh the gateway (Bind To Gateway) in another PowerShell script. These two tasks, running sequentially, now run successfully in our DevOps Release Pipeline.

Hope this helps someone.

Re: Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with P

Anonymous — Mon, 21 Jun 2021 05:44:16 GMT

HI @mbutler71,

Thanks for sharing, This should help if someone faced similar requirements.
BTW, I think you can also consider submitting ideas or contact the power bi dev team to report this requirement to help improving power bi features.

Regards,

Xiaoxin Sheng

Re: Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with P

mbutler71 — Mon, 21 Jun 2021 15:57:48 GMT

Not sure where to submit that, but they should allow the Service Principal accounts to be added to the Gateway Datasource "Users."
That would help. It would allow us to use one account for the whole process.

Re: Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with P

Anonymous — Tue, 22 Jun 2021 06:45:08 GMT

Hi @mbutler71,

You can discuss these on the power bi 'feature release' blog('power bi xxxx feature summary' which mentioned the embedded features) or submit and the idea forum.

Here is the link of ideas foumn:

Power BI Ideas

Regards,
Xiaoxin Sheng

Re: Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with P

mbutler71 — Tue, 22 Jun 2021 17:51:33 GMT

All set, thanks for the link:

https://ideas.powerbi.com/ideas/idea/?ideaid=d7bb30d3-5ed3-eb11-ba5e-501ac50a6edb

Re: Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with P

khemkandel — Fri, 22 Jul 2022 12:54:20 GMT

Hi,

I am using org service account that's synced to Azure AD. When I manually login (Login-PowerBIServiceAccount) it works - I get pop up to login where I would enter service account anme and password into my org login page. Then it connects and I can bind the gateway. However when I try to use below code for automation, it doesn't work.

$PbiSecurePassword = ConvertTo-SecureString $password -Force -AsPlainText
$PbiCredential = New-Object Management.Automation.PSCredential($username, $PbiSecurePassword)

Connect-PowerBIServiceAccount -Credential $PbiCredential
Login-PowerBIServiceAccount -Credential $PbiCredential

Any Ideas: I am thinking that it's because I am not using @onmicrosoft.com account and for some reason PowerBi commandlet doesn't support connect / login doesn't support accounts that are synced via Azure Sync??

Any advise is appreciated.

Thanks

Re: Automating Updating a Dataset's Datasource and the Gateway Datasource "Maps To" with P

m-colbert — Fri, 22 Jul 2022 15:00:31 GMT

@mbutler71

When adding data source users in the gateway admin, you can specifiy a security group. If you add the service principal to the security group, this should then allow you to use the service principal to bind the gateway datasource.
Hope this helps.