Quickbooks Integration with PowerBI

[maazbinsalman99]

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

[KNP · Accepted solution]

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.

[v-veshwara-msft]

Hi @maazbinsalman99 ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-kpoloju-msft]

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.

[Ritaf1983 · Accepted solution]

Hi @maazbinsalman99 

Please relate to the linked guides :
https://www.youtube.com/watch?v=fNMmcgi6I4w

https://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

[KNP · Accepted solution]

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.