analytics

DQ with Enterprise Gateway for PostgreSQL

July 27, 2019

directquery, enterprisegateway, gateway, customconnector, odbc, analytics

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] ( /posts/directquery-postgres-howto/) And utilize that service to run on an enterprise gateway. ...

DQ with Postgres from PowerBI Desktop

June 15, 2019

directquery, postgres, customconnector, odbc, analytics

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