Financial Reporting, Power BI, Uncategorized

Sample Financial Reports for Adventureworks (Updated)

** Update 29/05/2021 – Newer samples are now available on GitHub at https://github.com/ProdataSQL/FinancialModelling

The PBIX is preloaded, so you don;t need to load files, but if you don want to, you will need to change file locations to match where you ahve downloaded files too **

I updated my AdventureWorks Sample Report to include CashFlow, so we now have the three core areas of GL in one PBIX.

  • Profit and Loss
  • Balance Sheet
  • Cash Flow

You can download the PBIX from below link

https://github.com/ProdataSQL/FinancialModelling

To see my sessions on Creating Financial Reports in PowerBI you can drop by previous online seminars such as:

https://sqlbits.com/sessions/event20/Financial_Modelling_with_Power_BI

Published by Bob Duffy

4 thoughts on “Sample Financial Reports for Adventureworks (Updated)”

  1. Hi Bob,

    I came across your excellent YouTube vid yesterday and decided that I wanted to deepen my understanding by taking you up on the offer to download the PBIX and source files. However there seems to be an issue with the source files and the Power Query transformations. A key issue was that the PQ transformations in “Financial Report” refer to columns that are not included in the source file (“LineNo”, “LinkLineNo”, and “LinkSignage”). I couldn’t find a way around this so I’m hoping that you will consider looking into this and fix?

    I’ve been hoping for a video just like this, where the parent-child pattern from “the Italians” is extrapolated for actual financial accounting. To be fair on Alberto and Marco they do state in their patterns that there are more things to think about before using in management accounting.

    In any case – thank you for taking the time!

    Regards – Ragnar

    Reply

    1. Hi,

      The sample model is already fully loaded so you shouldn’t need to load the source files. If you do want to you need to change the path of the files to match where you may have downloaded the file to.

      Also, I added a new version of the sample reports to GitHub now.
      https://github.com/ProdataSQL/FinancialModelling

      Best Regards,
      Bob

      Reply

  2. The source files isn’t working. When enter in power query no load correctly

    Reply

    1. Hi,

      The sample model is already fully loaded so you shouldn’t need to load the source files. If you do want to you need to change the path of the files to match where you may have downloaded the file to.

      Also, I added a new version of the sample reports to GitHub now.
      https://github.com/ProdataSQL/FinancialModelling

      Best Regards,
      Bob

      Reply

Leave a Reply