Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Excel integration with PoweBI

Geetings, i have been using Excel since God created this earth 🙂 , well from very long time i have many reports in excel which are little comples, has lots of formulas and lots of graphs.   now ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Welcome to the dark side.

 

"now i need to convert them into PowerBI reports, what is the easy way?" 

 

Yeah, no.  Don't try to "convert".  Create a Power BI report that answers your business questions.  Don't waste your time trying to make Power BI behave like Excel.  We have a phrase for that - "Fighting the API".  The reason that both Excel and Power BI exist is that they are different. 

 

Power BI supports relatively solid data models, and it supports (much) larger amount of data than Excel. It also is missing a lot of the features that you are maybe taking for granted in Excel. 

 

your items 1 and 2 are covered by Power Query - depending on your Excel version you may already have worked with that.

 

When you run Power BI Desktop and click on the Help menu there is a plethora of (really good) training documents and videos. I would encourage you to spend some time there.