Notifications
Clear all
Power BI
2
Posts
2
Users
0
Reactions
118
Views
Topic starter
HI Mynda,
Do you have any suggestions for creating a Power BI dashboard with MYOB data?
Many Thanks,
J
Posted : 09/04/2023 9:57 am
Hi Jay,
Depending on the version of MYOB that you have, there are some connectors available:
Otherwise, if you prefer to export your data as per the attached file, then you'd need to use Power Query to unpivot the date columns before loading to the data model.
Note that creating P&L and Balance Sheets in Power BI is not straight forward (a Google search will suggest some tutorials), so you're best to use Power BI to look at insights and high level figures, rather than financial reports.
I hope that points you in the right direction.
Mynda
Posted : 09/04/2023 8:16 pm
