Forum Discussion

dramus's avatar
dramus
Continued Contributor
10 years ago

Power BI Enterprise Gateway - Error setting up Datasets

I'm trying to create a dataset to an oracle database.   When I try to apply the dataset I'm getting the following error: Unable to connect: We encountered an error while trying to connect to cab_p...
dramus's avatar
dramus
Continued Contributor
10 years ago

I have a Personal gateway running on the same box. If I stop it, I can create the dataset.

 

I thought it was acceptable to have both a Personal and Enterprise gateway installed on the same server.

  • wissink8382's avatar
    wissink8382
    New Member
    10 years ago

    When you stopped the Personal Gateway, were you able to restart it and have the datasets refresh using the Personal Gateway?  I'd like to replace all of the datasets under the Personal Gateway eventually, but can't replace all of them right now.  Can I just stop the Data Management Gateway Service to create the connection to the file in the Enterprise Gateway, then restart the service?  

  • Fredrik's avatar
    Fredrik
    Advocate I
    10 years ago

    I got a similar error when trying to replace the Personal Gateway with the Enterprise Gateway. I had both configured on the machine and all datasets were using the PG. I added equivalent data sources to the EG and they were working OK. I then switched from the PG to the EG on alla datasets but now got a generic "unknown error in Enterprise Gateway" error code -2147467259. If I stopped the PG service (also set it to manual to prevent it from autostarting if server reboots) everything was working OK. It seems that you cannot have both running at the same time although several MS articles say that this should be possible. When chatting with Power BI support they have also said that the PG is going away soon.