Forum Discussion
CBergsma
5 years agoFrequent Visitor
Change data type in Added Items part
Hello everyone: I've a tricky question, for some reason the view that i'm fetching data from it's having a date for Febraury 29th of 2021 (like this year would have a Leap Day), obviously this gi...
lbendlin
5 years agoSuper User
Power Query has a concept of "try - otherwise" for error handling but that will not help you much as it nullifies the entire step. Is there no way for you to catch that obviously wrong date already in the SSAS cube?
- CBergsma5 years agoFrequent Visitor
Sorry it took me so long to answer, we don't have a SSAS cube, we're trying to read directly from a view created in SAP Hana. We're already talking with the data provider to solve the wrong date, but we are trying to find a meanwhile solution so we can run the report again.