How to transform multiple tables in one excel sheet to one table with Power BI

0 votes

I would like to transfer this humanly readable table either into one long table, for example through an "Attribute" Column which then includes "Category A" and "Category B" or I would like to split them into multiple sheets within PowerBI. The "delimiter" is always a empty column.

Multiple Tables in one sheet

Mar 31, 2022 in Database by Edureka
• 13,630 points
1,216 views

1 answer to this question.

0 votes
If my prediction is correct-

You have a single spread sheet with data from several categories.
You wish to import all of your data into Power BI.
However, each category will require its own sheet.
You can get your desired data sets in Power BI by following the steps below:

Set the sheet to power bidding mode.
Duplicate your data set as many times as you wish, depending on the number of data sets you have.
Remove all columns from all data sets except the ones you need in the current data collection.
This should give you the data sets you want in power bi.
answered Apr 4, 2022 by Edureka
• 13,630 points

Related Questions In Database

0 votes
0 answers

How to DROP multiple columns with a single ALTER TABLE statement in SQL Server?

In one ALTER TABLE statement, I would ...READ MORE

Sep 2, 2022 in Database by Kithuzzz
• 28,320 points
142 views
0 votes
1 answer

How to drop all tables from a database with one SQL query?

Use the INFORMATION_SCHEMA.TABLES view to get the ...READ MORE

answered Feb 4, 2022 in Database by Neha
• 8,940 points
2,245 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,630 points
967 views
0 votes
1 answer
0 votes
1 answer
0 votes
0 answers

Convert a vertical data in a excel sheet with one header

I have a problem converting a long ...READ MORE

Apr 7, 2022 in Database by Edureka
• 13,630 points
67 views
0 votes
0 answers

How to find sum of multiple columns in a table in SQL Server 2005?

I have a table Emp which has these rows: Emp_cd ...READ MORE

Aug 19, 2022 in Database by Kithuzzz
• 28,320 points
728 views
0 votes
0 answers

How to update two tables in one statement in SQL Server 2005?

In one operation, I want to update ...READ MORE

Aug 20, 2022 in Database by Kithuzzz
• 28,320 points
139 views
0 votes
1 answer

How to enter a series of numbers automatically in Excel

Excel, unlike other Microsoft Office programmes, does ...READ MORE

answered Apr 4, 2022 in Database by Edureka
• 13,630 points
165 views
0 votes
1 answer

Excel - how to calculate sum of multiple rows into different columns

The AutoSum button or formula can be ...READ MORE

answered Apr 4, 2022 in Database by Edureka
• 13,630 points
4,904 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP