Forum Discussion
Working with a Table of Tables
I am trying to create a dashboard based off a spreadsheet that is shared on our internal sharepoint. The formatting of the sheet is not conducive to creating a Dashboard I have attached a sample of what it looks like below. How Can I get this into a format that is just one large table with the date repeated for each row of the corresponding sub table
2 Replies
- Sujit_Thakur
Solution Sage
Dear Anonymous ,
You can try cut and paste from excel to cut and paste different tables on different excel file
And then use combine folder option from get data
You will get a combined data 👍
If it help please choose this post as option
And do give kudos from thumbs up button
If you still have doubt please tag me and reply
Will be happy to help
Regards
Thakur Sujit
- Icey
Community Support
Hi Anonymous ,
If each table is saved as oen file, try to use combine files option.
Reference:
Combining Excel Files hosted on a SharePoint folder with Power BI
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
