Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Should I break dataflows up into multiple premium workspaces?

We have about 40 dataflows that refresh daily.   Some from our ERP, some from Salesforce.  

 

I was thinking to create two workspaces (we have a P1 Capacity SKU), and delineate the dataflows between ERP and Salesforce. 

Right now they are all in one workspace and we keep having refresh issues, especially with our scheduled refreshes.  

 

Does separating them into different workspaces offer any benefits, performance or otherwise?  

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    No we have others with access that can take over the dataflow if needed.   But in any case, I've confirmed that report users do not need access to the dataflow workspace in order to see the reports (which are in a different workspace).  

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    There will be no performance imrovement - that would only happen if you distribute the refreshes across capacities, and only if those capacities have enough free renderers. 

     

    From an organizational perspective it may make more sense but it comes with the additional baggage that you now have to maintain two (or more) sets of permissions.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    In my case the data flows are not used by anyone else.  The datasets are of course, and they have permissions set.   But even the datasets are not used by anyone else since I am the only author.   So do the permissions on the data flow workspaces really come into play?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Looks like you have bigger problems than dataflows. You being the single point of failure, for starters...

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      No we have others with access that can take over the dataflow if needed.   But in any case, I've confirmed that report users do not need access to the dataflow workspace in order to see the reports (which are in a different workspace).