cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

Hello everyone.  Long time lurker, first time poster.  

I'm working with another department on getting some of their data into PowerBI from excel spreadsheets.  When I load the file to PowerBI I get a simple yet very frustrating error message of...

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

Now this is a very complex spreadsheet with multiple tabs and lots of data.  Any commonly known issues that would prompt this error?

16 REPLIES 16
Highlighted
Frequent Visitor

After I installed the Aug 15, 2018 release of Power BI I experienced this issue with a couple of Excel files. I have recreated these files as Excel tables (no formulas, no formatting) and I was able to refresh the files successfully.

Highlighted

Hi,

 

I am facing the same issue as above, However i am copying the whole file and paste it as value.

 

However its giving me sam error.

 

Kinldy suggest!

Highlighted

This problem arises when the Excel workbooks have cells with malformed URLs.

 

As a workaround, you can create an environment variable named "PQ_DisableNet45Containers", with a value of "true".

 

We are working on a fix that we hope to include in the September release of Power BI Desktop.

 

Sorry for the incovenience this is causing.

Highlighted
Anonymous
Not applicable

Just updated an hour ago and am still getting the error message (which only pops up when loading a table that's an append of multiple tables that all load just fine otherwise)

Highlighted

I was having the same issue - the workbooks were very simple but I believe the issue was probably caused by malformed urls as previously mentioned.

 

However, after downloading version 2.62.5222.761 published Sep 18, I found everything to be working. 64-bit version in case that matters.

Highlighted

Will this be fixed for Power Query in Excel too, that's where I'm having the error and where most will too.


@SidJay wrote:

This problem arises when the Excel workbooks have cells with malformed URLs.

 

As a workaround, you can create an environment variable named "PQ_DisableNet45Containers", with a value of "true".

 

We are working on a fix that we hope to include in the September release of Power BI Desktop.

 

Sorry for the incovenience this is causing.


 

Highlighted

We believe this should have been addressed in all Power Query hosts.

 

Which version of Excel are you currently using? Which version of Power Query does that version of Excel currently have (available via Get Data -> Query Options -> Diagnostics).

 

Thanks

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors