Forum Discussion
Power Bi deployment pipeline with Azure Devops and Snowflake
Hi,
I am trying to setup Power BI CICD in Azure DevOps. I am using Power BI Action to publish report and update datasource connection.
I have seen that there is already a great post regarding this topic : https://community.fabric.microsoft.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244/page/3#comments
However, this post proposes to use a powershell script or Power BI action extension with Odata in regards to data source update.
I would like to know how I can update the data source when using snowflake as part of the CICD in Azure Devops with the Power BI actions extension.
Here is the a screenshot of the options I have :
I would like to know what I should select to update Datasource connection when using snowflake ?
My goal is to create a pipeline to deploy Power BI reports from UAT to Prod where reports and datasets in the UAT workspace have to point only to UAT databases and reports and datasets in the PROD workspace have to point only to UAT databases.
In Power BI Service, I know that I can use a rule to update a parameter but it is a very manual and time consuming to apply this parameter to all reports. Also, I would like to ensure that Row Level Security remains during that process.
Here is my current pipeline. Is this the right approach ?
trigger:
- task: PowerBIActions@5
Thank you in advance for your help !
Best,
Gabriel
HI gbc40,
According to your description, it seems like you are working with analysis service data source. So I think the data source type part should be 'AnalysisServices'.
For the PowerBIPath, maybe you can try to use ‘relative path’ of the rest API that you used to update the data source:Full URL: https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/Default.UpdateDatasources
Relative path: datasets/{datasetId}/Default.UpdateDatasources
BTW, the docuemnt mentions dataset created or modified using the public XMLA endpoint aren't supported. Are you working with XMLA endpoint? If that is the case, you should modify them to use the Azure Analysis Services client library for Tabular Object Model at first.
Datasets - Update Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Regards,
Xiaoxin Sheng
2 Replies
How on earth did you conclude that the original poster is trying to set an Analysis Services data source?
They are clearly asking about Snowflake so I can't fathom how this answer was the accepted solution. Come on, Microsoft!HI gbc40,
According to your description, it seems like you are working with analysis service data source. So I think the data source type part should be 'AnalysisServices'.
For the PowerBIPath, maybe you can try to use ‘relative path’ of the rest API that you used to update the data source:Full URL: https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/Default.UpdateDatasources
Relative path: datasets/{datasetId}/Default.UpdateDatasources
BTW, the docuemnt mentions dataset created or modified using the public XMLA endpoint aren't supported. Are you working with XMLA endpoint? If that is the case, you should modify them to use the Azure Analysis Services client library for Tabular Object Model at first.
Datasets - Update Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Regards,
Xiaoxin Sheng
