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
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.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors