Get data excel to power bi with sheet name

Get data excel to power bi with sheet name

4 file in one folder

Each sheet

Other sheet

Open power bi and get data from folder and browse

Edit:

Split file name in two column

Remove other column

Add custom column, name it and with formula

After edition

Remove binary column

You can show table in bottom by mouse over

Expend it

Expend table

Rename column, adjust left right by move, select 3 and remove other column

Now you can view heading by mouse over on table

If not all properly then

Promote header by selecting that column, add custom column, name it and write formula

You can view result my mouse over and remove older column

Adjust column

And expend it

Check and set formatting and give final name to database

Load and apply

Check region and sale and apply pi chart

Product and sale

Sale manger

Now add one sheet to any table and check result by refreshing