User Profile
NotEinsten
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
Re: Random date error
I tried playing around with formats, changing locale language/units, loading a fresh version. None worked so far. Also tried cleaning formats and then using format painter from some of the rows with same type of data to ensure correct format. Didnt work either. I circumvented the problem so far by creating a separate excel file with the "problem column", importing it separately and then establish relationship between the data sets in Power BI. Im starting to wonder, if it might have something to do with a capacity issue somewhere in the Office suite. The spreadsheet has more than 1 million rows and 20+ columns.Re: Random date error
Hi, thanks for replying If I format the excel-doc to text the cells containing actual dates get turned into nonsense, so thats not an option. The same goes for converting to "standard"-type. Below I attached a picture of the part of the excel-doc. The column acting up making error in Power BI is marked with a star. The columns marked with check mark gets imported without any trouble. All three columns are formatted as date with the same typographyRandom date error
Hi Tried following tips from a bunch of posts in here but failed to solve my problem, therefore this post. I apologize in advance if its a dublet of a former post i failed to find. My problem is a DataFormat.Error occuring after load or in during transforming of an Excel sheet. Interestingly, the error only happens in a specific column, even though the same symbol occurs in other columns with the same format/data type. The specific error is caused by a hyphen (-) placed in cells formatted as data type "date". This is directly imported from Excel, which put the hyphen there automatically due to the cells being of "date"-format and no date has been entered (its an end-date, so for tasks not yet completed, there is of course no date to be put in yet. I tried following the steps outlined in the posts "https://community.powerbi.com/t5/Desktop/Date-format-error/m-p/130510" and "https://radacad.com/flawless-date-conversion-in-power-query" but without luck. Does anyone have a tip for me?
