PBIX file in CI/CD pipeline

Question

Hi guys,I'm trying to put our PBIX files into a CI/CD pipeline.I found out how to upload PBIX files to the serivce via PowerShell, works fine. I found out how to change server name and database name (through API, either via parameters or directly).What I struggle with is&nbsp;how to change credentials for the deployed dataset.Any ideas?Thanks!

parik · Answer

Hi, any ideas how to approach this are really appreciated. I hope we are not the only one who has a test environment and who wants to automate the deployment process :)
Do you all really manually change the username/password when you are deploying to PROD?
I hope there must be some way to automatize that.

Thanks for any comments!

anonymous · Answer

Hi,&nbsp;I don't think that functionality is available directly within the Powershell Module. If you're using Azure DevOps then there's a plugin available to do what you're asking. Alternatively you could use the&nbsp;Invoke-PowerBIRestMethod method but you need to do some work to create the payload. Also check out&nbsp;Possible to update credentials via REST API?&nbsp;for more information.&nbsp;&nbsp;Tim

parik · Answer

Hi Tim,thanks a lot for the answer! We are on Azure DevOps. We tried the plugin, but it seems it can only change server and database names. That is also possible to do via API.What I'm after is changing user name and password - if the Power BI Actions extension can do that, then please correct me - to me it seems it does not provide option for changing credentials of a deployed dataset.Invoke-PowerBIRestMethod also does not seem to be useful, because AFAIK there is no API for changing user names/passwords.Petr

jayendran · Answer

Hi&nbsp;parik&nbsp;,&nbsp;Unfortuantely the PowerBI Actions is not capable of updating the credentials.&nbsp;&nbsp;Already a seperate thread is open for your same query.As per that you can use the below 2 API to achieve your request&nbsp;To get&nbsp;the Datasource and gateway id (Virtual Gateway NOT the typical on-premises/personal gateway) the user should use this API:GET&nbsp;https://api.powerbi.com/v1.0/myorg/datasets/{dataset_id}/Default.GetBoundGatewayDataSources&nbsp;&nbsp;Response:&nbsp;{
    "@odata.context": "http://wabi-europe-north-b-redirect.analysis.windows.net/v1.0/myorg/groups/xxxx-xxxf/$metadata#gatewayDatasources",
    "value": [
        {
            "id": "xxx-xx-xx-xx-xxx",
            "gatewayId": "xx-xxx-xx-xxx-xxx",
            "datasourceType": "Sql",
            "connectionDetails": "{\"server\":\"xxxx.database.windows.net\",\"database\":\"xxxx\"}"
       }]}&nbsp;and then to use the set credentials API.PATCH&nbsp;https://api.powerbi.com/v1.0/myorg/gateways/{gateway_id}/datasources/{datasource_id}&nbsp;Body{"CredentialType": "Basic", "basicCredentials":{"username":"xxxx","password":passs#1123"}}

jayendran · Answer

Hi&nbsp;parik&nbsp;&nbsp;I just finshed my article, you can find the full details here.&nbsp;https://social.technet.microsoft.com/wiki/contents/articles/53172.azuredevops-cicd-for-powerbi-reports.aspx&nbsp;Best of Luck !

Forum Discussion

PBIX file in CI/CD pipeline

7 Replies

Related content

Gen2 Dataflow (CI/CD)

Medallion architecture with CI/CD Pipelines

Complete CI/CD pipeline for Fabric

fabric ci/cd release pipeline

Lakehouse Schema - Tables CI / CD