Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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
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
Successfully did so. Thank you again.
Jim
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |