Connect Power BI to your Sage 50 OData Feed
This blog describes part four of a four-part process to connect Power BI to Sage 50 using the Suntico BI service. In this blog I show you how to link your Sage 50 company (or companies) that you have in your Suntico account to Microsoft Power BI. We will look at two examples:
- Connecting your Sage 50 company to the "Accounting Insights for Sage 50" Content Pack on the Power BI Service.
- Connecting your Sage 50 company to Power BI Desktop.
You can do either or both. Maybe it is a good idea to connect to the Content Pack first, as that will give you a ready-made dashboard and report that you can start to use right away. Meanwhile, you can connect to Power BI Desktop and start to build out some custom reports is you alsow wish to. To get you started with Power BI Desktop you can also download a Power BI Template file that will save you a lot of work setting up your Sage 50 model.
Let's start with the common activity that you will nee to do, and that is to generate your Power BI keys (username and password) for the Suntico BI OData feed.