V Videos

Warning! Advanced! Integrating Xero with Power BI | PowerBI Custom Connectors

February 16, 2024

1 min read

Hi there,

In this video, you can learn how to utilise PowerBI custom connectors to integrate Xero with PowerBI. It’s a bit more advanced than my usual tutorials, so I hope this doesn’t discourage you from watching 🙂

In this video, I’m focusing on the overall mechanics – I’m not explaining how to write Custom Connectors – there’s another video upcoming covering just that – but you’ll use the code I’ve written for you.

This video has taken so much time ahhh 😀 Hope you like it!

Contents:
0:00 – Intro

1:20 – Enabling custom connectors in PowerBI
2:18 – Installing VS Code
2:39 – Installing PowerQuery SDK
3:09 – Getting Xero’s Client ID
5:39 – Defining Xero Scopes
8:54 – Using my custom connector code
11:22 – Importing the connector into PowerBI
12:39 – Testing the code
17:13 – Publishing the report
18:07 – Installing PBI gateway

Lovro Suhadolnik

Hi! I'm Lovro. I'm a business analyst and a developer working with Microsoft software (SharePoint, Dynamics, PowerApps, PowerAutomate). I'm also a full-stack developr focusing on React, NodeJS and ASP.NET. I really enjoy preparing documentation and tutorials. I help companies become more agile by streamlining their processes and capturing the knowledge. I'm also a father. You can find my blog here, where I write about technologies I find interesting, my experience with parenting, and random ideas I think about.