cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gsunilkumar145
Regular Visitor

unable to refresh the report by using On premises standard gateway (postgres server)

Hi All,

I have installed Standard On-premises gateway in same server where is my data in postgres database.

I have installed to supporting .net 4.8 version but i got the below error & then installed the Npgsql 4.0.10 version.

 

Server name & database is same as desktop version pbi file & postgres server authentication details also verified but after publishing am unble to connect to the server through gateway. Please find the below screenshots for your reference.pbi_gateway_1.pngpbi_gateway_2.png

1 ACCEPTED SOLUTION
gsunilkumar145
Regular Visitor

Thank you all

I got the solution, Please follow the below steps.

 

Step1: Install the latest version .net frame work (4.8).

Step2: Install the Onpremises Gateway in same server where the data base is stored.

Step3: Install the Npgsql 4.0.10 version with GAC

Step3.1: Select the GAC drop down & choose entire futures will be installed in local drive.

Step4: Restart the server.

Step5: Please check in power BI services gateway services is running as shown in below screen. 

gsunilkumar145_0-1656583159549.png

 

View solution in original post

1 REPLY 1
gsunilkumar145
Regular Visitor

Thank you all

I got the solution, Please follow the below steps.

 

Step1: Install the latest version .net frame work (4.8).

Step2: Install the Onpremises Gateway in same server where the data base is stored.

Step3: Install the Npgsql 4.0.10 version with GAC

Step3.1: Select the GAC drop down & choose entire futures will be installed in local drive.

Step4: Restart the server.

Step5: Please check in power BI services gateway services is running as shown in below screen. 

gsunilkumar145_0-1656583159549.png

 

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors