Forum Discussion
Helper IIGrouping data in dev environment and production environment
where I come from we call this "wash me but don't make me wet".
One way to work around this is to make regular copies of the production environment into the DR environment and then point DEV and ITG to the DR environment.
Helper IIwe are trying to limit access to PRD database directly, hence the setup. Most of the cases, we are fine, we use test database to build the schema and then once the data is deployed to the end of deployment pipeline, it can use that schema to retrieve the Prd data. Now the grouping feature of Power BI use the actual data, so we havent found a way to "dynamically" do it, hence the question. I was thinking about a staff grouping table from an Excel file so that I can have 1 for test environment and 1 for Prd. However, not sure if the grouping feature can be "dynamic" that way.
Super Userwhere I come from we call this "wash me but don't make me wet".
One way to work around this is to make regular copies of the production environment into the DR environment and then point DEV and ITG to the DR environment.