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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

Check out the March 2024 Power BI update to learn about new features.