Forum Discussion

hale's avatar
hale
Icon for Helper II rankHelper II
4 years ago
Solved

Grouping data in dev environment and production environment

Hi,   I would like to set up a group in a dimension table (Staff). The issue is I use deployment pipeline and my dataset in each stage and desktop is using a different data source connection. There...
General Comment
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

hale's avatar
hale
Icon for Helper II rankHelper II
4 years ago

Thanks for the reply.
My current set up is desktop file connect to test database only. Production database can only be accessed inside company network via on-premises gateway. Once the dataset is published from dev computer, it will then be moving through pipelines and when it reaches the Prd workspace, it has all correct connection. It has been working perfectly until the need of grouping staff together (test db and Prd db have slightly different staff list).

 

I hope this makes sense now.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago
Production database can only be accessed inside company network via on-premises gateway.

If it can be accessed via gateway then it more than likely can also be accessed via Power BI Desktop. Gateway cluster members are pretty much headless Power BI Desktops.