Power Platform Community Forum Thread Details

Hi,

Where to find the data import logs while CDS data import from Excel. I get the successfull import but 0 record(s) imported.

Regards,

Neo.

Categories:

Building Power Apps

Hi @neocrm41,

Do you want to find the CDS data import logs within PowerApps?

Currently, if you want to see the CDS data import logs within PowerApps, I afraid that there is no way to achieve your needs.

Based on issue that you mentioned, it seems that you don't upload your Excel data into your CDS Entity successfully.

Please check if you have specified a primary key in your Exported Entity template. Please check the following article for more details:

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

In addition, you could also consider import data into your CDS Entity via clicking "Open in Excel" option within your CDS Entity. Please check and see if the following blog would help in your scenario:

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

You could also take a try to import your Excel data into your CDS Entity using Power Query functionality. Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-cds-newentity-pq

The user @KeithWhatling also provided another solution to achieve same needs. Please check the response within the following thread:

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/PowerApps-Cannot-Import-Data-into-CDS-Entities/td-p/171063

Best regards,

Kris