Quickbooks Desktop Excel Report formatting

Power BI Data Model
1

I’m curious if anyone has any recommendations for formatting standard P&L reports from QB Desktop so that they can be brought into Power BI for analysis. The current structure of these reports unstructured to properly pull into PBI. Here is a typical example:

30%20PM

Thanks!

2

Hi Guner,

Yes this can be difficult to get right in Power BI, that is why I devised a great solution just for this.

Check out this workshop here that runs through reporting templates.

Around the 22 minute mark is when I begin discussing this.

Sam