0 Kudos

The input couldn't be recognized as a valid Excel document

Status: Accepted
by Albihany Visitor on ‎01-16-2017 01:40 AM

Dear Microsoft,

 

This is really frustrating and to be honost this is not the first time it happens to me i have a very critical and important work that i need to finish and i can't understand why this issue is happening to me, it seems that the compatibility of the data types between excel and PBI is not coreectly done.

 

My issue is that i keep getting this message:

The input couldn't be recognized as a valid Excel document

 

Whenever i try to get the data from my excel datasheet with one column of type short date, i have tried deferent date formats and i'm still getting the same error message, i remember this was never an issue before and i could've use the same file as data source without a problem before this new year update.

 

Please let me know how i can solve this issue, as i'm running in very tight deadline and i have to finish a donor report.

 

PS: I looked at this issue and it doesn't solve anything : Click Here

 

 

Status: Accepted
Comments
by SteveNovoselacT Occasional Visitor
on ‎01-16-2017 02:34 PM

I am getting this same issue. It worked a couple weeks ago.

 

I updated PBI desktop today to latest still didnt fix. 

 

I have tried to pull in data via Excel using Get Data there and it works fine, but my gut is telling me that PBI Desktop somehow is having issue with Excel version/driver or something

by Community Support Team
on ‎01-18-2017 05:41 PM

@Albihany

 

What is your Windows OS here? Could you please take a look at this issue which is caused by the win10 insider update. Please let me know if your issue is same as that one.

 

Best Regards,

Herbert

by Vicky_Song Established Member
on ‎01-18-2017 05:42 PM
Status changed to: Needs Info
 
by SteveNovoselacT Occasional Visitor
on ‎01-18-2017 06:39 PM

Yesterday I did some testing and narrowed it down to the latest Win10 Insider Update, yes!

 

everything works excel pulling in data from excel sheet that has a table. excel sheet with data (not in a table) works fine. 

 

 

by Albihany Visitor
on ‎01-19-2017 12:47 AM

Hi @Vicky_Song My OS is Windows 10 Insider Preview Build: 15007.

Well i could solve the issue copying the dataset to a new excel document but this time i haven't make any tables and i also didn't change the type or format for the columns that holds the date fields, and somehow it accepted to import the dataset and recognized the columns of date as date in PBI.

 

It would be great if you can investigate this issue.

 

Many Thanks

 

 

by Community Support Team
on ‎01-19-2017 05:11 AM

I’ve reported it internally to Power BI Team: CRI 29920719

I’ll post here once I get any update about it.

 

Best Regards,

Herbert

by Vicky_Song Established Member
on ‎01-19-2017 10:03 PM
Status changed to: Accepted
 
by dcohendumani Frequent Visitor
on ‎01-25-2017 09:24 AM

I am having the same issue since the latest Windows 10 Insider Update. Build 15014.

 

This is frustrating. Beside uninstall the insider preview, any other ideas?

by Community Support Team
on ‎01-25-2017 10:33 PM

Hi All,

 

Since the insider version is a beta operation system of dubious stability. This is not supported today. Power BI team will file a tracking bug for this issue.

 

Best Regards,

Herbert

by tkr_office Frequent Visitor
on ‎02-01-2017 11:56 PM

Hy,
I had this problem myself.
After deleting sheet by sheet, I found out that the Power BI/ Q can load the excel.
After deleting row by row in the problem sheets, I found out that the Power BI/ Q gave this error,
when there were Active hyperlinks in cells.
After removing hyperlinks the xlsx just loaded.
So if you store www.google.com in a cell it's working.
But when the www.google.com is an active hyperlink (clickable, blue underlined text, which goes to specified address) it says:
Unable to connect
We encountered an error while trying to connect.
Details: "The input couldn't be recognized as a valid Excel document."

Idea Statuses