cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DirkG Frequent Visitor
Frequent Visitor

Power BI service Excel Online doesn't show any data.

Hi,

I have a problem when adding excel sheets to power bi service.

I use the "get data" => "Files" => "Local File" select the xls file.

I get the message to go to the workbook, then the Excel Online screen appears but no data is show. Only the cursor (the small dots going in circles).

I know the excel sheet is loaded because when i create a dashboard based on the excel sheet i see data.

I have tried this in Edge\Chrome and Firefox but no data in the excel online screen is shown.

Thanks

6 REPLIES 6
Community Support Team
Community Support Team

Re: Power BI service Excel Online doesn't show any data.

Hi @DirkG ,

How did these data stored in your excel worksheet? You imported data to excel file or only store a link who point to specific datasource? Please explain more detail information to help us clarify your scenario.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
venal New Contributor
New Contributor

Re: Power BI service Excel Online doesn't show any data.

@DirkG 

can you please confirm us, is that excel file extension is xls/xlsx?

 

If it .xls file, save as it into .xlsx and try to upload it now.

 

Please check the link.

DirkG Frequent Visitor
Frequent Visitor

Re: Power BI service Excel Online doesn't show any data.

Yes it is an xlsx file, no complexity whatsoever just 2 columns and 10 rows with data.

I did follow the steps mentiond in the link.

DirkG Frequent Visitor
Frequent Visitor

Re: Power BI service Excel Online doesn't show any data.

Below the steps i followed. The sheet is realy simple, no formulas just two columns and 10 rows with data.

 

2019-10-05_23h45_34.png

venal New Contributor
New Contributor

Re: Power BI service Excel Online doesn't show any data.

@DirkG 

I tried to re-pro the issue with the sample data.

EMPNOENAME
7369SMITH
7499ALLEN
7521WARD
7566JONES
7654MARTIN
7698BLAKE
7782CLARK
7788SCOTT
7839KING
7844TURNER
7876ADAMS
7900JAMES
7902FORD
7934MILLER
7985PINAL
7986VIPUL

tried to upload the file in Power Bi Service with Upload option from the Get Data.

 

workbook-1(Chrome).JPGworkbook-2(Edge).JPG

 

Close the Excel file and try to upload it once again.

 

If you still get any issue, please submit a ticket.

DirkG Frequent Visitor
Frequent Visitor

Re: Power BI service Excel Online doesn't show any data.

Stil the same Smiley Sad

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors