Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
TWMY1014
Resolver I
Resolver I

Fail to upload a Direct query report with data store in Postgres due there's no data gateway

Hi All,

 

I create a report in composite mode with source from 2 Postgres views - one was in import mode and another in direct query mode.
Everything works fine in Power bi desktop, but when I upload to Power bi service, those visual from direct query mode were all broken with message there's no available gateway. Other visual from import mode works.

 

Previously I've download an on-premises data gateway (personal mode) but it didn't support direct query,  I ask IT to download on-premises data gateway (standard mode) but it's fail to installed, part of error log in below:

TWMY1014_0-1713865763506.png

 

I have a premium Power bi service account but am not the IT admin. 

 

We used to publish the report to internal colleagues who have no Power bi license, we did this for a long time already but it's the 1st time we try use direct query.  

 

Apart from install on-premises data gateway (standard), any other method can be used ?

Thanks a lot for the help !!

 

Regards,

T

 

1 ACCEPTED SOLUTION
audreygerred
Super User
Super User

Hello! You can refresh data from Power BI service without a gateway if PostgreSQL is hosted in a way that allows direct connection from Power BI Services on Azure. If your PostgreSQL is hosted on Azure, this is natively supported, but if it is hosted on another environment you would have to check with that provider to see about configuring to allow for direct access. Also, if PostrgeSQL is configured to prevent direct access from the interenet (which if often recommended for security reasons), you'll need the gateway.

 

Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

4 REPLIES 4
audreygerred
Super User
Super User

Hello! You can refresh data from Power BI service without a gateway if PostgreSQL is hosted in a way that allows direct connection from Power BI Services on Azure. If your PostgreSQL is hosted on Azure, this is natively supported, but if it is hosted on another environment you would have to check with that provider to see about configuring to allow for direct access. Also, if PostrgeSQL is configured to prevent direct access from the interenet (which if often recommended for security reasons), you'll need the gateway.

 

Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Hi Audrey,

 

Thanks a lot. The postgresql was not in cloud enviornment so we need a gateway.  We'll have ~100 staff (max) viewing the report at once, those user had no Power bi license, tha's why we have premium license. 

If this is the situation, did postgrs situated on premises + on-premises data gateway vs. postgres on Azure, which one is better ?

Since yours is on-prem you absolutely need a standard gateway. If you were hosting it on Azure you wouldn't need a gateway. If you were hosting it on some out cloud server, you would need to see with that server if it is possible for direct connection without a gateway (and of course, your IT team).




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Thx a lot Audrey.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors