Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Experts,
I am facing an issue with the data type for the column below :
From the data source (Sharepoint list) , also having whole numbers , in that case i dn't know which data type to choose from power query.
I cannot able to fix this as i have tried to change data type into "text" but still it is not fixed. showing errors of 369 rows .
Please help to fix this asap
Thanks
DK
Solved! Go to Solution.
@lbendlin I have updated the text data type in M code and it is sorted now . Thanks 🙂
Those are text values, not integers.
@lbendlin I have updated the text data type in M code and it is sorted now . Thanks 🙂
@lbendlin yes but tried to change as "text" data type but not fixed , still error exists 😞