Forum Discussion
Connection to SQL from developer pc through On Premise Gateway
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:
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
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:
For each data source you have then to configure the gateway to connect to the correct on premises database.
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.
