Forum Discussion
Quickbooks Integration with PowerBI
Hi Team,
I am starting off on a project, to make reports out of Quickbooks on PowerBI. The QB intui application is on a remote server that is accessed via VPN. Can you outline what are the possible steps and ways to connect. Help would really be appreciated. Any free or paid methods please
You'll either need to install the Power BI Gateway on a machine that has the VPN always on or, if possible, install the Power BI Gateway on the same server as the QB application.
I don't know much about the QB side but I believe there are settings to allow ODBC connections to QB.
Alternatively, a third party option like https://skyvia.com/data-integration/analyze-quickbooksdesktop-with-powerbi or something from CDATA may help.
Please relate to the linked guides :
https://www.youtube.com/watch?v=fNMmcgi6I4whttps://www.youtube.com/watch?v=zYEHQLhA9H4&t=6s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
4 Replies
- KNPSuper User
You'll either need to install the Power BI Gateway on a machine that has the VPN always on or, if possible, install the Power BI Gateway on the same server as the QB application.
I don't know much about the QB side but I believe there are settings to allow ODBC connections to QB.
Alternatively, a third party option like https://skyvia.com/data-integration/analyze-quickbooksdesktop-with-powerbi or something from CDATA may help.
- Ritaf1983Super User
Please relate to the linked guides :
https://www.youtube.com/watch?v=fNMmcgi6I4whttps://www.youtube.com/watch?v=zYEHQLhA9H4&t=6s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
- v-kpoloju-msftCommunity Support
Hi maazbinsalman99,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to Ritaf1983, KNP, for those inputs on this thread.Has your issue been resolved? If the response provided by the community member Ritaf1983, KNP, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum. - v-veshwara-msftCommunity Support
Hi maazbinsalman99 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.