Connect to powerbi service without prompting for entering credentials

Question

Hi, My name is Gayatri. I am working as a Intern. I want your help. I am trying to run script in powershell for connecting to powerbi service without prompting for entering credentials. But its not working properly giving so much error. Can you please help me. How should I do this?

Code:

Import-Module MicrosoftPowerBIMgmt

Import-Module MicrosoftPowerBIMgmt.Profile

$password = 'abcde' | ConvertTo-SecureString -asPlainText -Force

$username = '******@gn.com'

$credential = New-Object -TypeName System.Management.Automation.PSCredential -argumentlist $username, $password

Connect-PowerBIServiceAccount -Credential $credential

Answer 1

Hello

Thank you for your question and reaching out.

Please use below code if it works for you , also please Disable MFA for this user.

---

#Variables

$PbiUser1 = "myUser@ mydomain.com"

$PbiPassword1 = "MyPassword"

#Create secure string for password

$PbiSecurePassword = ConvertTo-SecureString $PbiPassword -Force -AsPlainText

$PbiCredential = New-Object Management.Automation.PSCredential($PbiUser, $PbiSecurePassword)

#Connect to the Power BI service

Connect-PowerBIServiceAccount -Credential $PbiCredential

---

--If the reply is helpful, please Upvote and Accept as answer--