import errors from Excel

[JimB-GA]

Hello community,

I have a CSV file that is generated from Intuit's Mint app which I bring into Power BI.  There are about 10,000 rows.

For some reason there are 4 records that cause the refresh function to report an that an error occured and which I need to clear before proceeding.  Looking at the error table, I see that there is an error in the Date column.  When I go into the CSV file and look at the row numbers referenced in the error report, there is no apparent issue with the date field in the record.

Nontheless while the error is reported, the results from the query show the rows in question in the table.

I am wondering if there is an error trapping function in DAX that will let the query run without generating an error message.

I suspect that there is more information needed.  Please let me know and I will reply immediately.

Thanks for your assistance.  

Jim B  

[v-danhe-msft]

Hi @JimB-GA,

From your description, I could not see any error table, could you have posted it? And could you please offer your CSV file to have a test if possible?

Regards,

Daniel He

[JimB-GA]

After looking at my transactions.csv file I note that the 4 errors coincide with a Notes field. I removed the notes and the records import successfully.

[v-danhe-msft]

Hi @JimB-GA,

It's pleasant that your problem has been solved, could you please mark the reply as Answered to close this topic?

Regards,

Daniel He

[JimB-GA]

I have attempted to do so but the page returns the following error. Authentication failed for the action you are trying to do. This failure could be due to your browser not supporting JavaScript, JavaScript not being enabled, or trying to use the action URL directly in the browser address bar instead of clicking the link on the page.

[v-danhe-msft · Accepted solution]

Hi @JimB-GA,

You could try to clean up your browser cache and re-sign in the community to test if the answer could be marked.

Regards,

Daniel He

[JimB-GA]

Successfully did so.  Thank you again.

Jim