Forum Discussion

kooroshpashaei's avatar
kooroshpashaei
Frequent Visitor
9 years ago
Solved

multiple data sources on multiple PCs or computers

Hello all,

 

Is it possible to have multiple data source on different computers ? If yes how to connect them through gateway ?

 

Thanks in advance.

  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi kooroshpashaei Personal Gateway is not what you need here.  You'll need the On Premise Data Gateway.

16 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Yes you can, although i'd recommend these be servers rather than computers as computers are more likely to get turned off.

     

    When you set up your gateway, in your Power BI service online, you set up each data source in there.  Inside your Power BI file on your desktop, as long as each datasource has the exact same 'location', the data gateway will happily take over.

     

    A note of caution, since these locations need to be the same, instead of "C:\Folder\File.xlsx", use the path that an external computer would use, such as "\\Computer\Folder\File.xlsx"

     

    Naturally you'll need to make sure these are shared and your gateway has access.

    • kooroshpashaei's avatar
      kooroshpashaei
      Frequent Visitor

      Hi Ross, Many thanks for your reply. Please let me try and check it. 

       

      Best regards

    • kooroshpashaei's avatar
      kooroshpashaei
      Frequent Visitor

      Hi Ross, The main problem is I cannot access to Power BI GatewayPersonal setting so that I can change the path of data source. How we can change it ? For instance how we can change path from C:\DAT207x to own location. ?

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi kooroshpashaei Personal Gateway is not what you need here.  You'll need the On Premise Data Gateway.