Forum Discussion

H_Jones's avatar
H_Jones
Helper I
8 years ago
Solved

Oracle connection, Sessions per user Limit

Hello,   I have started noticing a big issue with my oracle connection to Power BI.   I currently have numerous reports using Oracle which are published to Apps and are refreshed each morning usi...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    H_Jones,

    Gateway doesn’t release the connections after refreshing datasets. In your scenario, go to Task Manager and kill the process "Microsoft.PowerBI.DataMovement.PersonalGateway.exe", then check if the connections are killed. After that, relaunch the "On-premises data gateway (personal mode)" configurator, and retry configuration.

    However, if the issue still persists, I would recommend you use on-premises gateway to refresh your dataset, and periodically run the following script to restart gateway service to force Power BI on-premises gateway to flush out its connections after refreshing.


    net stop PBIEgwService
    Taskkill /IM EnterpriseGatewayConfigurator.exe /F
    timeout /t 30
    net start PBIEgwService
    " C:\Program Files\On-premises data gateway\ EnterpriseGatewayConfigurator.exe "
    Exit


    There is also a similar thread for your reference.
    http://community.powerbi.com/t5/Integrations-with-Files-and/On-Premises-Gateway-utilizing-many-Oracle-database-connections/td-p/153324


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is this an issue that Microsoft plans on fixing? Either reusing existing connections, or even disconnecting so that it doesn't hit the session limit.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I resolved my problem, putting the data to my data warehouse and connecting the power bi on data warehouse.

 

Flow:

CUSTOMER DATABASE >> ETL >> DATABASE(DATA WAREHOUSE) >> POWER BI