Power Query – Software and Booz

Exchanging an OAuth Token in Power BI Custom Data Connectors

May 29, 2020 by Ryan

Custom Data Connectors can support multiple kinds of authentication. For most modern web apps, OAuth is the obvious choice and the Power Query SDK, coupled with the authentication examples (here and here), make it easy to setup. Unfortunately, two apps that I have recently created Custom Data Connectors for were partway through an OAuth implementation. … Read more

Organizing Functions in a Power BI Custom Data Connector

May 26, 2020 by Ryan

The more complex a Power BI Custom Data Connector gets, the more cumbersome the main Power Query file becomes. Without the ability to make a true “project” structure and include or directly reference functions from other files at this point, I wanted to find a way to keep things a little more organized. In the … Read more