Forum Discussion
Power BI gateway data sources
"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
So there are 2 physical machine involved here-Machine A has gateway installed and Machine B does not(User Machine).
These are my suggestions:
1. If you need User using machine B to access data on the gateway box then you can add the user to the actual physical machine i.e the Machine A as a windows standard/admin user.
2. Give the user remote access abilities to the Machine A. This way the user can RDP into the Machine A has a virtual machine through remote session while using his/her machine B.
Note- User on machine B can create reports against any datasource and published to PowerBI services from this location on Machine A.
For the Gateway:
The Admin of the gateway needs to create a DataSource to associated to the gateway on Machine A, then on the user tab select users who can use this datasource.
Note the user does not have to be an admin of the gateway itself if that is what you want.
Thank you,
Conarl_On_BI
Hi,
I don't want user from machine A to connect to machine B, I just want user on machine A to create reports using data source connected to gateway on machine B.
Now I have data source connected to gateway. User from machine A is added as this gateway user.
When I try to create new report on machine A, there isn't any data source available.
When on machine A , using desktop version, I manually add new data source (the same as on gateway) and publish it to cloud, than I am able to create reports and data refresh is working via gateway. 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?
"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
Ok, so MS Power BI Gateway is only for data refreshing not accessing. Thanks.