PostgreSQL Live Connection Without a Gateway

Hi Anonymous 

If your data locates on an on-premises server, you will always need to use a gateway to refresh them on PBI Service. ODBC data sources also need a gateway to refresh.

To refresh the dataset without a gateway, you need to store the data on the Cloud where PBI Service is able to connect directly. You can refer to Power BI data sources - Power BI | Microsoft Docs to see which data sources don't require a gateway.

If you would like to store data in an Excel / CSV file in OneDrive for Business and use it as a data source, you can refer to below links for how to connect to it in Power BI Desktop. In this way, you don't need a gateway.

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

Refresh a dataset created from a .csv file on OneDrive - Power BI | Microsoft Docs

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.