Adding Dataset Parameters Replacements as Action
JulianMar11 opened this issue · 3 comments
Integrating an action to replace a specific dataset parameter value within thisextension would be great, since we could manage dataset source parameters such as the database connection detail centralized in DevOps libraries.
It is basically an integration of this extension:
https://marketplace.visualstudio.com/items?itemName=AliMostafa.set-power-bi-dataset-parameters&ssr=false#overview
Deployment rules are key feature of Power BI deployment pipelines.
Please add support for Deployment rules via Power BI automation tools, so that that can be defined and controlled from Azure Dev Ops pipelines.
I think the corresponding REST API are
- Update parameters in group https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-parameters-in-group
- Update datasources in group https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources-in-group
See API call to update parameters https://github.com/alim92/powerbi-vsts-extensions/blob/master/setpowerbidatasetparameters/setpowerbidatasetparameters/ps_modules/PowerBi/powerbi.psm1#L54
ParamsArray in a json format: Example: [{"name": "MaxId","newValue": "5678"},{"name": "StrParam","newValue": "Another Hello"}] according to https://github.com/alim92/powerbi-vsts-extensions/blob/master/setpowerbidatasetparameters/readme.md
To set a parameter the dataset ID needs to be provided. dataset IDs in a workspace can be retrieved using Get Datasets In Group
Also to know what parameters exist for a dataset you get this information using Get parameters in a Group
See also #25
+1 please 🙏