Forum Discussion

Sonashish's avatar
Sonashish
Resolver I
5 years ago
Solved

Using Combined Excel data and generate new report

Hello   I have multiple Excel Online files with below information, these excel hosted in SharePoint online. Each excel represent to different location like location1, location2, location3.   Exce...
Need Help
  • Sonashish's avatar
    Sonashish
    5 years ago

    Hello Lionel,

    Actually I found that whatever excel I am combining that sheet tab names are different. Once I renamed the sheet name as Sheet1 in all excel, everything was working as I am expected.

     

    However I did not found that in any bloh or post where it is mentioned that if you combine excel, sheet name should be same.

     

    Thanks

    SOna

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Sonashish ,

 

Did you create these two tables on the data source(SharePoint Online)?

You should first import excels from different locations on SharePoint Online to Power BI, then merge the tables (table 1) and create a matrix (table 2) with table1.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Sonashish's avatar
    Sonashish
    Resolver I
    5 years ago

    I manually combined the excel and able to create the first table and generate pivot table successfully and able to refresh only.

     

    However I am not able to combine the multiple excels from SharePoint online in PowerBI.  After combining the excels, it is always picking first excel only, not sure why? However I am able to combine multiple CSV. I posted same query in forum as well.