vreiche
Level 1

Quickbooks Online Connector for Power BI

Hey there!

 

I'm using the Quickbooks Online Connector for Power BI and I'm trying to connect to the Profit and Loss report, but I only see the basic tables like Account, Journal Entry, Bill, etc. 

 

Is there a way to pull the Profit and Loss data into Power BI report?

 

I see that there's API connections to the Profit and Loss Report in the API Developer Docs:

https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/profitandloss

 

Otherwise, if I can't get access with the built in connector, does anyone know what basic Quickbooks tables make up the Profit and Loss Report? I'd be more than ok with rebuilding the report if need be.

 

Thanks everyone!