cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
schwinnen Member
Member

Parameters in Power BI service

In Power BI online, we have 3 different workspaces:

Staging

Test 

Production

 

Within Power BI Desktop, we set up Parameters for server at database so that when we upload the file, Power BI service knows which server/database to pull the information from.  However, within the desktop file, there is a default server.  For us, this is production.  

So, I upload this file into our Test workspace and then I set the parameters for the file in that workspace so that it knows to point to the Test server.  If I make changes to the report and have to reupload it, it is going to overwrite the parameter to that it points to production.

Is there a way to keep the online parameters static so that it won't revert back to production every time I have to reupload?

 

Hopefully this makes sense.

3 REPLIES 3
Community Support Team
Community Support Team

Re: Parameters in Power BI service

Hi @schwinnen,

 

Why didn't your change the parameter to TEST in power bi desktop and reload the data before you publish the report to service?

 

Regards,

Frank 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
schwinnen Member
Member

Re: Parameters in Power BI service

I could do that, but that really doesn't help anything.  I have to change the parameter somewhere either way.  The hope is that the parameter would save in service so I wouldn't have to keep changing it.  Perhaps that is not possible.

Community Support Team
Community Support Team

Re: Parameters in Power BI service

Hi @schwinnen,

 

Based on my test, it is not possible to meet your requirement currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.