customconnector

PowerBi August Update

August 20, 2019
powerbi, customconnector, postgres

In something of a completely unexpected but very happy twist of events, the PowerBI team has decided to include an update to the native PostgreSQL connector which allows for (Beta) DirectQuery support. More info here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2019-feature-summary/#postgresql PostgreSQL native integration update As a result, I have committed some of my latest changes and published my first “dev” release here: https://github.com/sgoley/DirectQuery-for-ODBC-in-PowerBI/releases/tag/v0.1-beta However, as a result of this news, I’ll most likely ceasing updating the project in general until I get further updates around the features that will be supported in PowerBI’s native connector. ...

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