Date type errors - replace text values in datatype cellls

[Krishna09]

Hello,

I am creating a dataflow to import sharepoint file data to existing table in dataverse.

As I alredy defined data types in dataverse all column types should match. 

I have date columns in sharepoint excel file. where few row have text(Unclassified) but most of the cells date format is fine. Now with what type of value can I replace with Unclassified text in datetype column, so that it satisifies datetype?

Please guide me. 

[Krishna09]

@AntrikshSharma you are right Now the flow is runnning fine. 

I have one more table with almost same data types. I created a data flow to import data of csv file from sharepoint to existing table in dataverse. only 56 row were imported and I received an error. 

It says dataa source credientials are invalid. if it is so, how could it import 56 rows?.

how to solve this error?

Error message:-

The dataflow could not be refreshed because there was a problem with the data sources credentials or configuration. Please update the connection credentials and configuration and try again. Data sources: Schema evaluation did not return TableResult. Actual result type: Challenge, Bad credentials, Challenge type: Resource, DataSources:

[Krishna09]

@AntrikshSharma I replaced with null value. later when I publish, no data was imported to dataverse. Besides, I received an error. I tried to refresh twice. All the time I refresh , same error pops up.

Why this error?

how to rectify this error?

[AntrikshSharma]

@Krishna09 Maybe there are some other values in the column that are text, try to run a Distinct over that column.

[AntrikshSharma · Accepted solution]

@Krishna09 Replace the value with null and then change the data type, I assume the column isn't going to be used in a relationship.