Loading a Report and its Metadata into a Star-Schema

What I'm trying to achieve in short:

1. load report metadata into a metadata table
2. generate a uuid which is saved to the metadata table
3. load the report sales values and add the uuid

Key-Facts:

• I'm using PowerBI Desktop
• The Reports im loading are saved in an Excel-File
• There are different Reports saved on sepparat sheets of the Excel-File
• The different reports cannot be combine because they're holding different values. e.g.:
  • report1: values for 2 contries combined
  • report2: values for each company

Actual Goal/Challenge:

I'm loading a report which is mostly optimised for human reading . As you can see on the Picture below, there are 3 sections:

• Metadata
• Userdata
• Sales Values

I'm thinking on generating an uuid which will be saved in a Table called metadata beside of the metadata like username and currency.

In the next step i want to load the sales values of the report itself into another table called sales. In this process PowerBI should know check for the UUID according to the attributes in the report and then add the UUID into the sales table beside of the sales data:

• uuid
• sales
• year_quarter
• etc.

I think this is way more efficient and according best practice than just writing all the data into one single table which then has over 20 attributs/columns where a lot of them just reapeating itself from row to row.

I would be pleased if you can assist me on best practices to achieve a suitable solution 😃

Is there a better way, is this completly stupid, what do you think?

Thank you very much and have a good start into the week

MoE