Forum Discussion
KNO
Helper I
Helper IConnect to on-premise database through Gateway from my dev?
Hi I am thinking about a way to connect to a customer on-premise SQL db. I have done the following steps installed the On premise gateway on customers machine Created a Data source on power platf...
Burningsuit
Resident Rockstar
Resident RockstarHi KNO
You will need an account on the Customer's Power BI tennant. Then give that account access to the Gateway that serves the SQL database. You can then use Dataflows to create a connection to the SQL database, select and clean the table(s) you want from the Datasebase. You can then use Power BI desktop to pull the Dataflows into a Datamodel for visualisation. This way you only need a Power BI account in the customer's tennant. No need for Tunneling/VPN's etc.
Hope this helps
Stuart
KNOHelper I
Helper IHi and thanks for answers. I have one question. The account that should be created on the Customer Power BI Tennant, should that be an account bound to the customer tennant or can the customer just add my own account?