Because of security requirements, Quick Books has discontinued use of their online connector for several browsers including Internet Explorer. The problem with the Power BI connector is that Power BI uses Internet Explorer to authenticate its webservices. With discontinued support for this browser, Power BI can no longer authenticate the Quick Books connection. The error when trying this connection is typically labelled as “Script error”.
At FreshBI, we like to create solutions. We noticed this connectivity issue and decided to create our connection service that allows anyone to connect their Quick Books data to Power BI.
In this blog we’ll explain the basics of how our service can connect to your Quick Books data from the Power BI Desktop so that you can relax, knowing our service will give you secure and immediate access to the data that drives each of your reports.
With the Fresh BI Quick Books connection service, you’ll be able to connect to all reports and data endpoints available in Quick Books. This means you can access accounts, customers, actuals, budgets and more.
This connector can also be used for a Microsoft Excel connection. This includes all the same functionality as the Power BI connection. Simply follow the same connection steps and Microsoft Excel will be able to provide the same seamless connectivity with your data in Azure blob storage.