cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Get data from Excel - Unexpected Error

I'm using the PowerApps community edition.  From Data, Entities, I selected 'Get Data' then 'Excel'.  When I click the 'Browse' button, next to the 'File path or URL' prompt, the 'Unexpected Error' message is displayed.  I was able to do this before in a trial environment for the same organization.   Is this a bug or a limitation of the community edition?

 

Thanks.

Paul

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: Get data from Excel - Unexpected Error

Hi @pfurb ,

Could you please share a bit more about your error message?

Do you want to import data into a CDS Entity from a Excel file using Power Query?

 

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:2.JPG

 

Please consider take a try to clear cache of your browser, and make sure your Network is in a good condition, then try it again, check if the issue is solved.

In addition, you could also consider take a try with the "Get data from Excel" ("Get Data"-> "Get data from Excel") option and "Open in Excel" functionality in CDS Entity to achieve same needs.

More details about importing data into CDS Entity using "Get data from Excel" option, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-import-export

More details about importing data into CDS Entity using "Open in Excel" functionality within CDS Entity, please check the following article:

https://powerapps.microsoft.com/en-us/blog/cds-for-apps-excel-importexport/

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-excel-addin

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Get data from Excel - Unexpected Error

I tried the 'Get data from Excel' option as recommended and get the following error:

The import service is not available: Connection set initialization failed for project DMImport_2019_03_28T23_09_35_103Z. Error: Service principal couldn't be written

 

It looks like my community edition cannot access the files in my domain. I did not have this issue with the PowerApps trile, which recently expired.  Do you think I should delete then re-install the community edition environment?

 

Thanks.

Paul

Highlighted
New Member

Re: Get data from Excel - Unexpected Error

I'm also using the Community edition and experiencing the same "Unexpected error" when I try to import any data into a CDS entity. It is not restricted to Excel as it also affects CSV file import too. The error occurs when I click the Browse button.

CDSImportError.png

Highlighted
Regular Visitor

Re: Get data from Excel - Unexpected Error

I got the same problem and the solution is to use Google Chrome to get data.

Normally Power app tool work best with Internet Explorer but this time Chrome saves me.

Highlighted
New Member

Re: Get data from Excel - Unexpected Error

Experiencing the same issue today in my community environment. I am  receveing unexpected error when I try to get data from Access, Excel, etc sources. See the attached image. Is this an issue within the community environment ?

 

Highlighted
Regular Visitor

Re: Get data from Excel - Unexpected Error

Do we have fix for the issue.

I am also facing same issue in my community plan environment and unable to connect to any data source in the CDS

 

Highlighted
Frequent Visitor

Re: Get data from Excel - Unexpected Error

Getting the same type of error message. Anyone figured out any type of a workaround for it?

 

I am trying to get data into my Entry for CDS and all possible methods are failing me in this Community Environment!

 

Any help or direction woudl be greatly appreciated!

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (4,293)