Error We couldn t find any data in your Excel workbook

0 votes

I was importing an Excel workbook into Power BI, then facing the mentioned error above. Can someone suggest what to do to resolve this issue?

Oct 22, 2020 in Power BI by Rajiv
• 8,910 points
1,922 views

1 answer to this question.

0 votes

To import from Excel into the Power BI service, you need to format the data as a table. Select all the data you want in the table and press Ctrl+T.

Another Quick solution

  1. Edit your workbook in Excel.
  2. Select the range of cells that contain your data. The first row should contain your column headers (the column names).
  3. Press Ctrl + T to create a table.
  4. Save your workbook.
  5. Return to Power BI and import your workbook again, or if you're working in Excel 2016 and you've saved your workbook to OneDrive for Business, in Excel, click File > Publish.
answered Oct 22, 2020 by Gitika
• 65,890 points

Related Questions In Power BI

0 votes
1 answer

How to combine your data or tables in Power BI?

Power BI includes Query Editor which is ...READ MORE

answered Feb 27, 2019 in Power BI by Phalguni
• 1,020 points
2,802 views
0 votes
1 answer

Append excel data and In house database data that gets refresh evey 24 hour

Hi, You can try this way, A  -  Actual ...READ MORE

answered Mar 20, 2019 in Power BI by Sindhu
660 views
0 votes
0 answers

How to Fix error "DataFormat.Error: We couldn't convert to Number"

Hi,  I am getting below error "DataFormat.Error: We couldn't ...READ MORE

Apr 22, 2019 in Power BI by Lavdeep
• 120 points
14,535 views
0 votes
0 answers

DataSource.Error: ADO.NET: R script error. Error in is.data.frame(x) : object 'ALL_Data' not found

I am trying to export data from ...READ MORE

Feb 14, 2020 in Power BI by ankita
• 120 points
2,642 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
1,246 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
78,597 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
19,041 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,380 points
785 views
0 votes
1 answer

How to import data model from Excel in PowerBI?

You may try to divide your data ...READ MORE

answered Oct 22, 2020 in Power BI by anonymous
• 65,890 points
1,641 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