Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
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
Below the steps i followed. The sheet is realy simple, no formulas just two columns and 10 rows with data.
I tried to re-pro the issue with the sample data.
EMPNO | ENAME |
7369 | SMITH |
7499 | ALLEN |
7521 | WARD |
7566 | JONES |
7654 | MARTIN |
7698 | BLAKE |
7782 | CLARK |
7788 | SCOTT |
7839 | KING |
7844 | TURNER |
7876 | ADAMS |
7900 | JAMES |
7902 | FORD |
7934 | MILLER |
7985 | PINAL |
7986 | VIPUL |
tried to upload the file in Power Bi Service with Upload option from the Get Data.
Close the Excel file and try to upload it once again.
If you still get any issue, please submit a ticket.
Stil the same