Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |