Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NH
Advocate II
Advocate II

Aug 2018 Desktop version unable to recognize Excel file

Has anyone  encountered issue with Aug 2018 Desktop version that unable to recognize the excel file?

After I update to the Aug 2018 Desktop and I've encoutered one of my current Pbix file unable to recognize the one of the source Excel file with the following error message "The input couldn't be recognized as valid Excel document.

 

My colleagues who uses the earlier version doesn't has this problem with the same source Excel file. Thus I did a uninstall  to Aug 2018 version and re-install the Jul 2018 Desktop version and was able of import the same Excel file.

 

 

Thanks you.

 

 

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @NH,

 

It seems that you only have this issue for the specific excel data source?

 

I haven't encountered issue as yours until now.

 

If it is convenient, could you share the specific excel sheet so that I could make a test.

 

In addition, you could have a reference of these similar threads.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/The-input-couldn-t-be-recognized-as-a-v...

 

https://community.powerbi.com/t5/Issues/The-input-couldn-t-be-recognized-as-a-valid-Excel-document/i...

 

https://techcommunity.microsoft.com/t5/BI-and-Data-Analysis/quot-The-input-couldn-t-be-recognized-as...

 

Best Regards,

Cherry

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

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @NH,

 

It seems that you only have this issue for the specific excel data source?

 

I haven't encountered issue as yours until now.

 

If it is convenient, could you share the specific excel sheet so that I could make a test.

 

In addition, you could have a reference of these similar threads.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/The-input-couldn-t-be-recognized-as-a-v...

 

https://community.powerbi.com/t5/Issues/The-input-couldn-t-be-recognized-as-a-valid-Excel-document/i...

 

https://techcommunity.microsoft.com/t5/BI-and-Data-Analysis/quot-The-input-couldn-t-be-recognized-as...

 

Best Regards,

Cherry

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

I have the same problem. At least since the August update a PBI file with an excel file on sharepoint as datasource can't be refreshed in PBI Desktop (with the same error message). The refresh in the power bi service does work though.. Do you have an update on the issue?

 

Thanks! Jasper

Hi Cherry,

 

Thanks for you replied. Sorry I'm not able to share the source file. But I went to read out the below link regard to hyperlink in Excel file may cause BI unable to open the excel file issue. And I go ahead to remove the hyperlink in the excel file and it manage to resolve the issue. But I'm not able to duplicate the problem by adding back the hyperlink in the Exce file. Strange.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/The-input-couldn-t-be-recognized-as-a-v...

 

Thank you.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.