Forum Discussion
Converting Multiple Columns from Text to Date
I am using the excel sheet with 240 columns holding date values. When I getting data from this sheet into Power BI, the date columns are loaded as text. I ran a script converting all these columns ...
Isha wrote:
I am using the excel sheet with 240 columns holding date values. When I getting data from this sheet into Power BI, the date columns are loaded as text. I ran a script converting all these columns to Date format. Because of the high volume of conversion, Power BI is unable to apply this change. Any solution or workaround ?
Thanks
Are those 240 columns all used in your report? Try to filter and select the columns that only needed and try to do the conversion.
Yes Eric, all 240 columns are used and the list will keep growing, I unpivot data after bringing in Power BI to visualize it though. But after that if I need to plot timeseries based data into a visual, which needs the date columns in date format rather text.
Regards,
Isha.