Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Combining excel files

Hi guys ,   i have a big excel file with many sheets ,i need some guidance to work on it . First question , is it better to clean the excel file before connection to power BI (i have in one sheet ...
Need Help
Tips and Tricks
Edwin74's avatar
Edwin74
Frequent Visitor
6 years ago

Hi there,

 

Let's see if I can help, if only a bit 😉

 

Question 1: several tables on 1 Excel-sheet doesn't work well with Power BI. I used to end up with only the top table and the other table(s) on the same sheet left out.  Several sheets on the other hand poses no problem for Power BI. To me cleaning up/preparing Excel files was needed before connecting it to Power BI.

 

Question 2: Power BI doesn't combine sheets on itself. It lets you choose which sheets of a particular Excel-file you want to import. You get to select the sheets you want to import and before you actually import, you get the possibility to alter the layout of the tables. When several tables have been imported to Power BI you also have the opportunity to merge queries.

 

Hope this is of help.

 

Cheers,

Edwin