Connecting Lightspeed to Power BI

jtenney · August 19

I'm trying to connect our instance of Lightspeed Retail to Power BI so we can run customized reports ad-hoc inside of Power BI off of order data. However I'm not sure where to start or what is required to do so.

gregarican · August 20

Here's where you can get starting with the Lightspeed Retail API --> https://developers.lightspeedhq.com/retail/introduction/introduction/.

Hope this helps!

jtenney · August 20

How am I supposed to get authorization code if Power BI is run locally on my machine?

Adrian Samuel · August 20

Hey @jtenney,

You might consider using a custom data connector built by Microsoft like so:

https://github.com/Microsoft/DataConnectors

More details can be found here:

https://docs.microsoft.com/en-us/power-query/samples/trippin/readme

It enables you to write code to interface between PowerBi and any data source such as the Lightspeed Retail API

Connecting Lightspeed to Power BI

Answers