Forum Discussion

Akshay_M's avatar
Akshay_M
Helper I
7 years ago
Solved

Extracting data from Quickbooks Desktop?

I am working with a client who is wanting to extract QB Desktop data to Power BI so they can have customized reports, that are updated regularly (~15 min intervals is fine). I have seen a few tools o...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Akshay_M ,

     

    If you can publish data from QuickBooks desktop to QuickBooks online, then you can connect to QuickBooks Online in Power BI Desktop and Power BI Service to retrieve data, See: QuickBooks Online content pack for Power BI. Also there is already an idea about QuickBooks Desktop data source, you can vote on it: Quickbooks Desktop Version .

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi  Akshay_M ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

schlaj's avatar
schlaj
Frequent Visitor
6 years ago

Hi v-xicai, I am attempting to do this same action, downloading the dataset from the Quickbooks App that I connected to in PowerBI Online (sucessfully), but I can't extract the data in PowerBI desktop.  Any help would be appreciated! 

 

We couldn't export to .pbix format.
Please try again later or contact support. If you contact support, please provide these details.
Activity IDa88ba6ed-d686-4817-ba29-5ae8c54ed31a
Request ID5778c530-ff34-8235-5c8c-eb533ddb58d3
Correlation IDdc74665d-39b6-8730-0e86-f1c44cc8a60f
Status code401
TimeFri Oct 04 2019 12:54:58 GMT-0600 (Mountain Daylight Time)
Service version13.0.10882.216
Client version1909.4.015
Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net