How to connect to QuickBooks online database to analyze data in excel?

What do you mean by "connect"? You can export reports to XLS. Another option, utilize a business intelligent app to analyze your QBO data.

Hello there, @Siddique. 

I want to ensure you're able to analyze your data in QuickBooks. Therefore, I would like to ask a few verifying questions.

Are you trying to import a file or export a report? What did you mean by connecting to QuickBooks Online (QBO) database? Can you provide more details about your concern? Any additional info will help me provide the appropriate resolution of the issue.

Keep me updated in the comments below. Hope to hear from you as soon as possible. Take care and stay safe!

Is there a way to connect from excel or power bi to quick books online database to create and refresh datasets/reports/dashboard?

If you are using PowerBI, you need a 3rd party connector. Another option, user another BI app to connect with QBO natively.

Thank you for your quick reply, @siddique-mh-gmai.

I'm here to point you on the right path so you can connect QuickBooks using power BI.

Several third-party applications are integrated with QuickBooks Online to manage your business better. I advise getting in touch with our Intuit Developer for assistance with integrating your application with the program. They are the experts when it comes to enabling applications to access the production of QuickBooks Online companies.

You can contact them by clicking on this link: Intuit Developer.

Please let me know in the comment section, if you have more QuickBooks-related concerns. I'm around to take care of them for you. Stay safe always.