Forum Discussion

KNO's avatar
KNO
Helper I
5 years ago
Solved

Connection to SQL from developer pc through On Premise Gateway

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

Need Help

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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, SQL and Azure Blog (home.blog)

     

    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
     
    • KNO's avatar
      KNO
      Helper I
      5 years ago

      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.