Forum Discussion

PVosESKA's avatar
PVosESKA
Regular Visitor
4 years ago
Solved

Multiple duplicate datasources

Hi Guys, Long time PowerUser, first time poster on this board.   I recently got the task of optimizing workspaces and apps in our tenant. In our most important workspaces and apps, there are conne...
Dataflow
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    PVosESKA Not sure there is anything that can be done about it then. Since they are live connections to the cube, unless I am mistaken, you cannot have define a dataflow that is a live connection so no real way to consolidate.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

PVosESKA Are these live/directquery connections to the tabular cube or import?

  • PVosESKA's avatar
    PVosESKA
    Regular Visitor
    4 years ago

    Hi Greg_Deckler ,

     

    These are al live connections to the cube. Multiple workspaces, all with 10's of connections.

     

    Regards,

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      4 years ago

      PVosESKA Not sure there is anything that can be done about it then. Since they are live connections to the cube, unless I am mistaken, you cannot have define a dataflow that is a live connection so no real way to consolidate.

      • PVosESKA's avatar
        PVosESKA
        Regular Visitor
        4 years ago

        Hi Greg_Deckler ,

         

        Someone told me about a way of editing the datasets to use the same datasource, so 40 datasets could be using the same datasource.

        I just wondered if there is any benefit of doing this, but judging by your answer, having multiple duplicate datasource connections is a 'normal' thing.

         

        Thank you for taking the time to reply. I will mark your answer as the solution.

         

        Regards,

         

        Peter