DQ with Enterprise Gateway for PostgreSQL

Table of Contents TLDR ODBC DSN Installing and Managing a Personal vs. Enterprise Gateway Direct Query / Custom Connector settings for Custom Connectors PowerShell Module Service Setup TLDR This is to establish how to take the connector that you setup in my previous post: [DirectQuery Postgres How-To] ( /medium-posts/2019-06-15-directquery-postgres-howto/) And utilize that service to run on an enterprise gateway. I will be repeating a few steps from that post because I want this to be it's own “standalone” guide. [Read More]

DQ with Postgres from PowerBI Desktop

Table of Contents TLDR Postgres DSN Custom Connector for ODBC DirectQuery Enterprise Gateway ** Safety Briefing, this being a PowerBI custom connector, this is entirely focused on a Windows centric walkthrough as I'm not currently working with either a Linux or Mac OS environment. Not discriminating, just not available to me at this time. ** TLDR I was recently put in the situation of finding a way to reduce refresh time on a PowerBi embedded instance. [Read More]