Connection to SQL from developer pc through On Premise Gateway

[KNO]

Dear all

I really could need some help. I have several clients with own databases, but the db schema is the same. From PowerBI on my developer PC I would like to connect to an On Premise SQL Server Instance. And from there create a model to distribute to Power BI Services. Just the model. Then later create the report. 

Is it possible with an On Premise Gateway (https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem) ? And how would I go about doing that?

I am looking for the "right" way and to reuse models and extend the models with new functionality, and make small increment rollouts / improvements / updates.

Thanks

[selimovd · Accepted solution]

Hey @KNO ,

yes, you can set up the database name as a parameter. This can be changed then after uploading to the Power BI Services.

Check the following blog article on how to do that:

Moving Power BI to different Environments (Dev Test Production etc) – Debbies Microsoft Power BI, SQ...

For each data source you have then to configure the gateway to connect to the correct on premises database.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[KNO]

Thanks for your answer. I actually went another direction with data ingestion. I utilize Azure Datafactory and the Runtime Integration Gateway instead. That way I can manage the ingestion of data from many sources into one single repo. I am using the metasystem Common Data Model to structure my datasets.