Forum Discussion
Change parameter of data source in Advanced Editor
Hello guys, In my project, we have 2 environments Development and Production which should have same data tables with same columns, only data change. These environments are in 2 differents instanc...
amitchandak
Super User
Super UserAnonymous , You can use parameter
refer: https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
video from guyinacude
Hi
thank you for the solution !
I have Power BI RS and I found the behavior is really strange.
I think the parameter works on Server field but not on the Database field. When I change the value of the parameter for the server, the power query update it but it's not the case for the database. For the database, I noticed that the Power Query take the name of the parameter to put it in the information of the data source instead of taking its VALUE. So to make it works, I changed directly the name of the parameter so its value is useless
It's because of the version of Power BI ?