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.

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.