Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I need someone's help. Present I have connected to Dev database. In power query editor I have created two parameters. One parameter for server name and another parameter for database name. After close and apply . Before publishing the report to power bi service. Do we need to map the parameters in datasource settings?
Is it fine without mapping the parameters in datasource and directly publishing the dataset to workspace. In workspace only if we change the parameters to test server . Is it fine ?
Solved! Go to Solution.
Hi @muktapurc - Yes you are correct, No need to mapping the parameters in datasource. Pls follow below steps.
I hope this works for you. Thanks!
Thank you
Hi @muktapurc - Yes you are correct, No need to mapping the parameters in datasource. Pls follow below steps.
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.
Proud to be a Super User! | |
Thank you
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
87 | |
65 | |
50 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |