Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 upl...
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 ?

audreygerred's avatar
audreygerred
Super User
2 years ago

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).

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thx a lot Audrey.