Posts

On Landing a Rocket on an Autonomous Drone Ship

December 1, 2019
logo, design, meta

“Do that which is meaningful over what is expedient.” - Jordan B. Peterson When I originally set out to learn about data, statistics, and analytics, I did so because it basically ensured that I would have high quality employment for life. If I had to dream of something of a stretch goal, I might have said that if I did incredibly well, I might land a position of exploring particularly interesting data in the financial sector for a startup or a hedge fund. ...

Heroku Postgres and PowerBi

November 11, 2019
powerbi, heroku, postgres, data

I’ve been continuing to receive a very positive response on my custom connector project inspite of the release in August of PowerBi’s native support for DirectQuery. The reason being: similar to my own employer Finexio, there is a large number of startups depending on Heroku as an infrastructure platform. The primary issue being that when you attempt to make the connection in PowerBI using the native PostgreSQL connector, it depends on a certificate to make the connection secure. ...

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

Launch post!

July 29, 2019

In the interest of sharing some of the more eccentric cases of R, PowerBI, and many more of my frequently used platforms, I’d like to take an opportunity to share something of an official launch of my own personal content resource. For the sake of convenience, you should be able to reach my articles, portfolio (in development), and more through a variety of links all pointing to the same place: ...

On Premise Gateway Resource Links

July 29, 2019
gateway, onpremisegateway, powerbi

My submitted github issue for powershell command to set gateway anchor for cluster: https://github.com/MicrosoftDocs/powerbi-docs/issues/1005 Powershell support for gateway clusters: https://www.oreilly.com/library/view/mastering-microsoft-power/9781788297233/2a6f38cc-dfd9-4f77-95d4-d8c5ca84b7a1.xhtml Radacad powerbi gateway: https://radacad.com/the-power-bi-gateway-all-you-need-to-know Definitive guide: https://radacad.com/definitive-guide-to-power-bi-personal-gateway

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

Heroku Certification Notes

March 26, 2019
heroku, bash, learn, hosting, salesforce, certification

Table of Contents # Term List Heroku Services FDW / Data Links from Shield Env Heroku Connect To be completely honest, part of the reason I’m writing this doc is for my own study / self-reference as I prepare for Salesforces' Heroku Architecture Certification: https://trailhead.salesforce.com/credentials/herokuarchitecturedesigner Useful Quizlet resource: https://quizlet.com/387365689/heroku-architecture-designer-flash-cards/ Term List # https://devcenter.heroku.com/articles/glossary-of-heroku-terminology Covers the majors like: Add-on App Buildpack Config var Dyno ...

Using PowerApps and Flows to Refresh PowerBI Dataset

March 21, 2019
powerapps, flow, powerbi

Table of Contents # TLDR Use Case Microsoft Flow Powerapps Powerapps Embedded Visual Alignment Outcomes TLDR # Made a microsoft flow to trigger powerbi dataset refresh. Embedded a powerapp into powerbi report that contains trigger / button for said flow. Refresh button for powerbi dataset underlying report? Read more to find out! Use Case # I originally started out looking for ways to cause a powerbi dataset refresh from a report. ...