cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikkelD1234
Frequent Visitor

Problem with Excel upload

Hello everyone,

I'm encountering issues while attempting to import an Excel file into a table.

 

Error:

,"General error","Type=Microsoft.Dynamics.Integrator.Exceptions.IntegratorClientException, Msg=Unable to parse import file 5662e6f6429341348f36a490dbbeb015_AdditionalLocations.xlsx Error details PQOnline failure - Type=System.Net.WebException, Msg=The remote server returned an error: (400) Bad Request."

 

Thank you in advance!

 

45 REPLIES 45
DanielN
Frequent Visitor

Thanks, converting to csv file can now import.

Tried to use the Import Data option and looks like need a SharePoint or OneDrive License to use Excel import

DanielN_0-1712916705854.png

 



thchewningcofc
New Member

I was getting the same error message.  However, I used the same import button, but I selected import data instead of import data from excel.  This option walked me through the process and ended up showing up as a dataflow.  

 

Hope that helps!

Dianah_Ebere1
New Member

Hello @MikkelD1234 @thchewningcofc @DanielN @Barto_lomeo @Ekene 
I also encountered same issue, try fixing the problem by changing the excel file to csv, then import. 

rachnag
New Member

Hi,

 

I saved the file in .csv format and then imported. It worked fine.

Pavan_Mani_Deep
Responsive Resident
Responsive Resident

Hi All,

 

Make sure the file you downloaded from Power Query window is in proper format. The error message suggests that it is a parsing issue. Just ensure both are of same format.

 

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

 

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

 

Blog:https://ecellorscrm.com

 

Cheers,

PMDY

Hi, you have to run the app (use play button) and then select import from Excel > csv and the import window will pop up.

KJ

I did that too and that is how I got past that point after so many tries

 

KJW86
Advocate II
Advocate II

Hi,

 

I got the following error when trying to import the Excel file in the locations table:


The file could not be uploaded for Location: [UnknownError] Type=Microsoft.Dynamics.Integrator.Exceptions.IntegratorClientException, Msg=Excel file with more than one sheet is currently not supported.

 

Checked the Excel file; it is only one sheet, also the file is not open in Excel. I think this should work in Dataverse and is a bug as it offered as an option to import xlsx-files....

KJ

Pavan_Mani_Deep
Responsive Resident
Responsive Resident

Hi @KJW86 ,

 

Check if there were any hidden sheets in the excel file.

 

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

 

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

 

Blog:https://ecellorscrm.com

 

Cheers,

PMDY

Nope...

Helpful resources

Announcements

Learn what to expect in the Power Up Program

Since its inception in 2022, the Power Up Program has evolved based on feedback from learners and Microsoft Partners and customers. Today's Power Up learners can expect to learn the fundamentals of Microsoft Power Platform in the accelerated seven-week, video-based Power Up Maker course.   Hear from Principal Program Manager, Dimpi Gandhi to discover the latest enhancements and meet the Microsoft MVPs, Rory Neary and Charlie Phipps, who partnered with the Microsoft Power Up Program to create the Power Up Maker course to guide learners to use the Microsoft Power Platform to develop custom applications, build dazzling report dashboards, or create efficiencies through automation.  

Welcome to the Power Up Program Community

The Power Up Program is a free upskilling program where nontechnical people can learn the fundamentals of Microsoft Power Platform. The Power Up Maker course is a seven-week self-paced virtual learning plan that include video-based objectives featuring Power Apps, Power BI and Power Automate.  As a member of the Power Up Community, you can grow your skills and build connections. You can post questions to get help with the curriculum and hands-on exercises from experts and peers in the product boards.  Check out the Community Information & Feedback board to find help or provide feedback with the community experience, and please take time to post in the Social board to tell us more about yourself. If you're new to the Power Up Program and looking for information to register. You can sign up at PowerUp.Microsoft.com.

Top Solution Authors
Top Kudoed Authors
Users online (5,368)