Forum Discussion
Parameters usage in datasource
Hi muktapurc - Yes you are correct, No need to mapping the parameters in datasource. Pls follow below steps.
- After creation of Parameters in Power Query editor. Just you can close & apply.
- Then publish the report to DEV workspace. Upon publish sucessfull.
- Navigate to Power BI services and click on deployement pipelines.
- After opening deployement pipelines click on comparison then select your report and dataset and then click deploy to QA.
- After sucessfull deployement, Click on QA/TEST deployement rules. as shown in image.
- Then change the server name and database name with related to TEST worksspace. as shown in image.
I hope this works for you. Thanks!
Hi muktapurc - Yes, it's fine to directly publish the dataset without mapping the parameters in data source settings in Power BI Desktop. After publishing to the Service, you can change the parameters to the Test server, and it should work, provided your gateway and credentials are correctly configured.
Keepinmind: When working with parameters for server name and database name in Power BI, the workflow and considerations for publishing to the Power BI Service depend on how you've set things up.
sharing Reference links:
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
https://www.phdata.io/blog/how-to-parameterize-data-sources-power-bi/
Hope the above information helps.
Thank you
