Forum Discussion

mbutler71's avatar
mbutler71
Advocate I
5 years ago

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

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 corr...
General Comment
Tips and Tricks
khemkandel's avatar
khemkandel
New Member
4 years ago

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