cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MulinYong
New Member

Data modeling financial statements

Hi all,

 

I have a question on how to extract financial statement. For example, my profit and loss statement is being recorded in excel files therefore I suppose it is not Power BI friendly enough. May I check if there is any way to extract the information into power BI without having the users (accounts executives, etc) to duplicate the info into a proper rows and columns format?

 

Thanks in advance for the answers.

 

Regards

1 ACCEPTED SOLUTION
leonardmurphy
Skilled Sharer
Skilled Sharer

Power BI Desktop allows you to import data from Excel files, as well as manipulate the data during the import to make it into a 'rows & columns' format.

 

When you say 'Get Data' in Power BI Desktop, choose Excel and choose the file. After it connects, it will come up with a Navigator window with a list of sheets to import. Check the sheet(s) you care about, but rather than click 'Load' which will load the data as-is, click 'Edit'. This will bing up the query editor (better known as Power Query) which lots of options to delete rows, pivot/unpivot, replace values, filter the data, add calculated columns and such like. It's a very powerful tool that can replicate most things you would do manually to covert data into a proper rows & columns format.

 

The main prerequisite is that each file has to be formatted consistently. If each file is completely different, well, that could be a problem.

 

Hope this helps.

---
In Wisconsin? Join the Microsoft BI Professionals - Wisconsin group.

View solution in original post

2 REPLIES 2
leonardmurphy
Skilled Sharer
Skilled Sharer

Power BI Desktop allows you to import data from Excel files, as well as manipulate the data during the import to make it into a 'rows & columns' format.

 

When you say 'Get Data' in Power BI Desktop, choose Excel and choose the file. After it connects, it will come up with a Navigator window with a list of sheets to import. Check the sheet(s) you care about, but rather than click 'Load' which will load the data as-is, click 'Edit'. This will bing up the query editor (better known as Power Query) which lots of options to delete rows, pivot/unpivot, replace values, filter the data, add calculated columns and such like. It's a very powerful tool that can replicate most things you would do manually to covert data into a proper rows & columns format.

 

The main prerequisite is that each file has to be formatted consistently. If each file is completely different, well, that could be a problem.

 

Hope this helps.

---
In Wisconsin? Join the Microsoft BI Professionals - Wisconsin group.

View solution in original post

Solved it. Thanks for your help!

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors