Forum Discussion
Flybook-AzureAd
7 years agoNew Member
Design a report without production data
For security reasons I want users to design reports against a staging database and not use produciton data. Is there a way to design a report using staging data and then, when publushed, the report uses a production dataset. I am not seeing a way to change out the dataset on the fly or publish without a dataset.
1 Reply
- v-lili6-msftCommunity Support
hi, Flybook-AzureAd
I think you could use Parameters in Power BI like this before publish it to power bi service
https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/
https://community.powerbi.com/t5/Desktop/Parameterization-of-Data-Source-Connection/td-p/478453
Best Regards,
Lin