Forum Discussion
Data Conections on Power BI Service
We have a Power BI Pro account with many dashboards devs in the company, and everytime that we need to publish a new report on the Power BI Service, even if it's a personal workspace, a new data connection is created like the attached example.
I'd like to know if there is any setting to disable the automatic creation of these networks.
9 Replies
- collinqSuper User
HI KarineCruz ,
When you publish a report to the service it uploads the data model, including the dataset (now called Semantic Model). Part of the model is every connection that the report is using. And, this means that the data connection is automatically added if it doesn't already exist.
One way around this to add so many is to create the data connections that you want folks to use and then share that connection with those users. That will keep from redundant data connections but with different names from being added.
I do not believe that there is a way to turn this off as this is fundamental piece of the data model and the ability of the report to render.
- KarineCruzNew Member
Hello, Collinq! Thanks for your answer. The problem is that the gateway is centralized on a single server and the server don't have access on the file paths and is not possible configure that data conections.
- collinqSuper User
Hey KarineCruz ,
Hmmmmmm, that is not a very effective Gateway if it can't reach the data sources. I would recommend creating a new gateway or moving the one you have to a server and location where it can do its job effectively. The Gateway is designed to be the conduit between internal data sources and the Service and if you can't do that then you don't really need a gateway since you can't use it.