Power BI CICD- Unable to Refresh Report using SPN User

[Seshan]

Hi Community,

I have developed a pipeline for Reports deployment using Azure DevOps

I am able to export and import the reports from SPN User but unable to refresh the reports and on Power BI Service UI  it is throwing DataSource error. I am using CDS Datasource and moving reports from one workspace to another.

It says missing credentials, I am able to update parameter(Datasource URL) and using only 1 data source CDS connection. And when I tried with normal Master user it worked fine without any issue. 

Requirement is to perform with SPN User, posting Script as well below

Invoke-PowerBIRestMethod -Url "groups/$($workSpace.id)/datasets/$($datasetid)/Default.TakeOver" -Method Post -Body ""

# Update parameter's value
Invoke-PowerBIRestMethod -Url "groups/$($workSpace.id)/datasets/$($datasetid)/UpdateParameters" -Method Post -Body '{
"updateDetails": [
{
"name": "ParameterURL",
"newValue": "https://xxxxxxxx.crm.dynamics.com/"
}
]
}'

#Refreshes Dataset
Invoke-PowerBIRestMethod -Url "groups/$($workSpace.id)/datasets/$($datasetid)/refreshes" -Method Post -Body ""

This is a big blocker for me guys, I am unable to fully automate this process, a help will be appreciated guys.

@Jayendran ,I followed your process on Github, you could help on it

Thanks in advance. 

[shyammayhs]

Hi Seshan,

Were you able to find a solution for your problem?

Thanks.