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,870 points
2,263 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,770 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
3,085 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
749 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,856 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,761 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,472 views
0 votes
4 answers

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

R|ight click on the table you want ...READ MORE

answered Nov 18, 2022 in Power BI by Madelein Tolmay
79,476 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,406 views
0 votes
1 answer

How to Split Columns in Power BI?

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

answered Jan 6, 2024 in Power BI by anonymous
• 1,420 points
1,058 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,770 points
1,746 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