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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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