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

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

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