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.
Here's where you can get starting with the Lightspeed Retail API --> https://developers.lightspeedhq.com/retail/introduction/introduction/.
Hope this helps!
How am I supposed to get authorization code if Power BI is run locally on my machine?
You might consider using a custom data connector built by Microsoft like so:
More details can be found here:
It enables you to write code to interface between PowerBi and any data source such as the Lightspeed Retail API
API Integrations Consultant - Strategic Solutions