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 in Database by Edureka
• 9,320 points
31 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 by Edureka
• 9,320 points

Related Questions In Database

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 in Database by Neha
• 6,260 points
94 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 in Database by Edureka
• 9,320 points
30 views
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 in Database by Edureka
• 9,320 points
10 views
0 votes
1 answer

How to load data of .csv file in MySQL Database Table?

At first, put the dataset in the ...READ MORE

answered Jul 5, 2019 in Database by Reshma
681 views
0 votes
2 answers

How to select the nth row in a SQL database table?

SELECT * FROM ( SELECT ID, NAME, ROW_NUMBER() ...READ MORE

answered Apr 23, 2020 in Database by anand
• 140 points
15,486 views
0 votes
1 answer

How to check if a table exists in a given schema

Since you havent mentioned the DBMS in ...READ MORE

answered Oct 4, 2019 in Database by Daric
• 500 points
1,847 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 in Database by Edureka
• 9,320 points
20 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 in Database by Edureka
• 9,320 points
77 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP