Forum Discussion

sandiskajins's avatar
sandiskajins
Frequent Visitor
8 years ago
Solved

Power BI gateway data sources

Hello,     We have computer, where Power BI gateway is installed and configured to connect to our SQL Server DB. Now we want other user, who is working on another computer to access data from that...
  • Conarl_on_BI's avatar
    Conarl_on_BI
    8 years ago

    sandiskajins

     "Is this how Power BI /Gateway is working and every user who want to create reports should install desktop version and manually add data source to create reports?" 

    Yes, for the user to create report they need to install the client PowerBI desktop, then click on Get Data and select the respective DataSource such as SQL, HANA, file or any other DataSource in the list where your data lives. 

    Note that the user user have an account or use an account that as access to the underlying database or source. 

     

    Thank you,

    Conarl_On_BI

prihana's avatar
prihana
Helper V
8 years ago

Hi,  Ask the second user to add the datasource under the gateway and check.

sandiskajins's avatar
sandiskajins
Frequent Visitor
8 years ago

Under gateway settings, second user can see to which data source this gateway is connected. 

2nd scenario - user is added as gateway user not administrator. So he can't use "manage gateways" settings. What about this? He still should be able to use data source connected to this gateway and create reports, isnt't he?