cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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.Excel sheet data.PNG

 

 

 

Capture.PNG

 

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..

 

7 REPLIES 7
Moderator v-qiuyu-msft
Moderator

Re: not able to view uploaded excel file

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: not able to view uploaded excel file

@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:

Capture.PNGCapture1PNG.PNG

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

Thanks !

Re: not able to view uploaded excel file

Anyone can help me on this.

Moderator v-qiuyu-msft
Moderator

Re: not able to view uploaded excel file

Hi @chayanupadhyay,

 

Sorry for the late response. I'm not reproduce the issue on my side. You can download the attached Excel 2013 file and upload to your Power BI service to see if the visuals can load fine. The Sheet1 is getting data from the SQL Server data source, Sheet2 data is entering.

 

w4.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: not able to view uploaded excel file

@v-qiuyu-msft  Thanks for the reply.

But same thing, not able to view uploaded Excel shared by you.

 

 

Capture.JPG

 

Once i tried to disconnect from my organization network and connect to my own Internet but still not able to view uploaded excel.

Just want to confirm, is there any dependancy on Network when we are uploading Excel from our local drive means will there be any firewall or organization policy blocking the Excel ? 

Please provide your input.

 

Thanks !!

 

Moderator v-qiuyu-msft
Moderator

Re: not able to view uploaded excel file

Hi @chayanupadhyay,

 

That's strange. In my opinion, as you can access Power BI service via your network and upload Excel successfully, uploaded Excel should display fine on service.

 

Regarding this issue, I would suggest you let Microsoft engineer look into your workspace specially, you can create a support ticket here.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: not able to view uploaded excel file

@chayanupadhyay : did you sove this issue?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 60 members 1,172 guests
Please welcome our newest community members: