Forum Discussion

chayanupadhyay's avatar
chayanupadhyay
Icon for Helper III rankHelper III
9 years ago

not able to view uploaded excel file

I have uploaded Excel file in Power BI service, it is uploaded successfully but when i view the file, it is not loading..

My Excel file is containing two sheet, both sheet has 1 visual each.

 

 

 

 

Even i tried to import excel data and then also uploaded the excel but still not able to view it.

Anyone can help me on that..

 

General Comment
Interesting Links
Tutorial Requests

7 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi chayanupadhyay,

     

    Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 1 GB. Please check if your workbook meet this requirement. See: Get data from Excel workbook files.

     

    After you upload the workbook to the Power BI service, does it always display loading status? Is there any error throws out? Did you use Excel to get data from the external data source?

     

    Please share detail steps how you create the Excel workbook. If possible please share your Excel Workbook with us, so that we can upload to Power BI service to see if the issue is related to the Power BI service itself.

     

    Also you can create another simple Excel workbook which has the Pivot Table visual, then upload this workbook to service to see if the issue related to the Excel workbook.

     

    Best Regards,
    Qiuyun Yu

    • chayanupadhyay's avatar
      chayanupadhyay
      Icon for Helper III rankHelper III
      9 years ago

      v-qiuyu-msft Thanks for reply.

       

      Excel file size is less than 150 KB, Excel uploaded successfully shown message in power bi service, no error were thrown.

      It is just simple excel, I am using Excel 2013 (.xlsx) and it is simple Excel containing two sheet, both sheets is having one visual.

      I create one Pivot Chart by using External Data source connection.

       

      I also tried to upload excel containing simple data but still not loading, There is no option to upload my sample Excel in here but i will attach some of the snapshot:

       Please let me know if i am doing someting out of order or if there is any other issue...

      Thanks !