The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Hi Seshan,
Were you able to find a solution for your problem?
Thanks.
User | Count |
---|---|
5 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
11 | |
7 | |
5 | |
4 | |
4 |