Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 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 have created two Parameters in desktop one with UAT and Prod Server details another one with Database details. but here challenge is i don't have Production data base access.
Now i created dashboard with UAT Data source and publishing the dashboard in Workspace, from there i need to change the dashboard source from UAT to Prod so the dashboard will be refresh with Prod data.
i tried like below:
after Pubishing the dashboard in work space without enabling the Enterprise gateway directly i went to parameter and i was able to change Source from UAT to Prod then tried to enable gwateway server but still showing UAT details over there.
if i have Prod DB access then in desktop level i can change and i will publish. please let me know is there any othere way to figure out.
Solved! Go to Solution.
@PKR_N , refer to this blog if that can help in the approach you follow
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
or this video
connection as parameter
https://youtu.be/XIq5vN5oPf8
@PKR_N , refer to this blog if that can help in the approach you follow
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
or this video
connection as parameter
https://youtu.be/XIq5vN5oPf8
Thank you Amit
User | Count |
---|---|
120 | |
69 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |