QBO Dashboard Creation

[Anonymous]

I've successfully connected to the QBO database and brought in all fields but I need to see if there is a tutorial video or guide that helps me understand the relationships of the fields or if there's something like the web-based QBO pack for me to get started.

[v-piga-msft]

Hi @Anonymous ,

If I understand your question correctly that you want to know the relationship between the fields when load the data from QuickBooks Online in Power BI Desktop.

Actually, I'm afraid that we get data from QuickBooks Online via QuickBooks Online in Power BI.

So for your question, you'd better have a contact with the support of QuickBooks Online to get the most professional help.

If you still need help about Power BI, feel free to ask.

Best  Regards,

Cherry

[Anonymous]

Surely someone in this community has built dashboards from QBO data in the desktop version?

Contacting Quickbooks to understand the database structure is a complete waste of time.

[rdubs]

I have been using the QBO connector for about a year now. In a recent update (April I think) they changed the table options which made them very difficult to understand (I think it was by mistake). I have raised a ticket and asked them to investigate.

But for now the solution I have been using is to revert back to a previous version, which you can do from this link:

https://docs.microsoft.com/en-us/power-bi/desktop-latest-update-archive

I have been using February's version.

This should be a lot easier to understand and get what you need from it.

I have posted an idea on the power bi ideas forum, if you could vote for it maybe they will fix it:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/38064298-quickbooks-connector-rev...

Hope this helps,

Rory