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

sandiskajins's avatar
sandiskajins
Frequent Visitor
8 years ago

Hello,

 

I am testing Power BI tool.

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 gateway and create reports. We added that user as this gateway administrator and data source user. User logged in to his cloud Power BI account, he can see that gateway under “Manage gateways”, but he can’t use any data from DB that is connected to this gateway. When he choose to create new report, there is no any dataset to choose.

Could You please describe me how this is working and how we can use data from gateway. Install gateway to all user computers isn’t necessary, right?

 

Thanks.  

prihana's avatar
prihana
Helper V
8 years ago

Please add the SQL server as a data sorce from  the second users account in Gateway.