Forum Discussion

pedroccamaraDBI's avatar
pedroccamaraDBI
Post Partisan
5 years ago
Solved

Gateway - Which one

Hi everyone,
Maybe i haven't install correctly my gateway but it was working. It was refreshing the data from MySql and SQL Database as well as local (csv and xlsx) files. Suddenly it start to consuming a lot of ram memory and stop refreshing the data, and so i've uninstalled.
My first question is: which gateway (please with a link to download) should i install?
And second, do i have to install another gateway (with another email account) in order to refresh another data from an SQL server, from another client?
Thanks a lot guys but i'm still a litle confuse about these gateways stuff.
Best regards
Pedro

Need Help
  • AbhiSSRS's avatar
    AbhiSSRS
    5 years ago

    You would need to work with Standard mode Gateway. Also you do not need multiple Gateways for a single on-prem machine. So you can add multiple datasources to the same gateway as long as all the data sources are on the same machine as your gateway. 

    https://powerbi.microsoft.com/en-us/gateway/

     

    You can have sperate workspaces running reports for seperate clients using the same gateway. When you add the datasource they will ask for credentials which give it access to your local database/excel etc.

     

2 Replies

  • AbhiSSRS's avatar
    AbhiSSRS
    Solution Sage
    5 years ago

    You would need to work with Standard mode Gateway. Also you do not need multiple Gateways for a single on-prem machine. So you can add multiple datasources to the same gateway as long as all the data sources are on the same machine as your gateway. 

    https://powerbi.microsoft.com/en-us/gateway/

     

    You can have sperate workspaces running reports for seperate clients using the same gateway. When you add the datasource they will ask for credentials which give it access to your local database/excel etc.