Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a power Bi desktop and report server version. I get the data from SQL server stored procedures.
My requirement is when I create or test any report it should use my testing environemnt and once I deploy to production it should connect to production environment .
Both of my develpment and production servers are different. I have a reporting server too.
Solved! Go to Solution.
Hi @spathak04,
In my opinion, I'd like to suggest you to parameterize your query tables with query parameters, then you can simply switch data source between test and production environment on power bi service side.
There are some reference links about blog and document below, please take a look on it to know more steps:
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,
Regards,
Xiaoxin Sheng
Hi @spathak04,
In my opinion, I'd like to suggest you to parameterize your query tables with query parameters, then you can simply switch data source between test and production environment on power bi service side.
There are some reference links about blog and document below, please take a look on it to know more steps:
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,
Regards,
Xiaoxin Sheng
Thank you somuch. I think this article could help me a lot.
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |