Forum Discussion
OLE DB or ODBC error: [Expression.Error] We couldn't parse the Duration literal..
Then there is an error in the conversion. After that step, go to the home ribbon, Keep Rows, Keep Errors. See what that returns. If you see a yellow "error" field, click next to the word error, not on the word. At the bottom of your screen it should give you a larger error message and the data it is having a problem with.
You need to post screen shots, link to a sample data file or something. It is very difficult to troubleshoot many transformation errors without specific info.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Community ChampionDuration is not a recognized data type by DAX or the Power BI Model jerrywalk1. That shouldn't cause the error, but you should explicitly convert it in Power Query. For example:
This Duration of 1 hour:
is converted to this fraction of a day on import.
It could be in PQ trying to automatically convert it in the import through Duration to Decimal it is crashing. So explicitly convert that duration field to a decimal number and see if that fixes it.
In my current query the very next step after changing type to duration is changing type to number. This was already step before the error.
- edhans
Then there is an error in the conversion. After that step, go to the home ribbon, Keep Rows, Keep Errors. See what that returns. If you see a yellow "error" field, click next to the word error, not on the word. At the bottom of your screen it should give you a larger error message and the data it is having a problem with.
You need to post screen shots, link to a sample data file or something. It is very difficult to troubleshoot many transformation errors without specific info.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.The above helped alot. I was able to see the error and i have about 12 rows that have 24:00:00 and the duration cannot parse that. Now I just need to figure that out. Whether to just remove those or figure out how to keep them.
Thanks,
Jerry
