Andy Parkerson Web Developer Extraordinaire Hero to the

Andy Parkerson Web Developer Extraordinaire & Hero to the Flemish Shoppers. Choice. com, LLC UGWEDNESDAY Custom Connectors in Power. BI

The Problem

The Problem Connectors to your data do not exist in Power BI. Google Analytics? Google Ad. Words? Bing Ads? Yahoo (Gemini) Ads?

Current Workflow Refresh Current Clever Workflow Refresh

The Other Problem

The Other Problem Your reporting team isn’t full of devs. “Can you help me with a query? ” “My report takes forever to refresh. ” “These numbers seem weird – can you take a look? ”

Other Current Workflow

The Solution

The Solution Custom Data Connectors

Old Workflows Refresh

New Workflow

What Custom Connectors can offer • Creating a business analyst friendly view for a REST API • Providing branding for a source that Power Query supports with an existing connector (such as an OData service, or ODBC driver) • Implementing an OAuth v 2 authentication flow for a Saa. S offering • Exposing a limited/filtered view over your data source to improve usability • Enabling Direct Query for a data source via an ODBC driver

Example • Nested API endpoints by category • Dynamically generated • ODBC allows for Query Folding • Won 2 nd Place in Hackathon

Takeaways • • Analyst Friendly Branded Pre-formed Queries Direct Query

Thank You Andy Parkerson andyparkerson@gmail. com Shoppers. Choice. com, LLC Leading E-tailer in BBQ Grills, Patio Furniture, Outdoor Kitchens PHP Developers Wanted: • Framework (Yii, Laravel, etc. ) • My. SQL • Java. Script / j. Query et al.