Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

WBS issue in Power Query - cannot change type to text

Hi everyone,   I have to do some analysis on the scheduele and I'm having trouble with the WBS column. When I import the csv (or excel), this column has a data type 'Any'. I noticed that majority o...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  Anonymous ,

     

    Yes,if you directly change the type to text or use Text.From,you will get a result as below:

    You could try to take below steps：

    Click "Add column">"Column From examples">Using below format:

    And you will see:

    For my sample .pbix file,pls see attahched.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi  Anonymous ,

 

Yes,if you directly change the type to text or use Text.From,you will get a result as below:

You could try to take below steps：

Click "Add column">"Column From examples">Using below format:

And you will see:

For my sample .pbix file,pls see attahched.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

  • amirshiloh's avatar
    amirshiloh
    Advocate II
    1 year ago

    that improves the situation- it reduce the number of lines with that WBS format error, but still havn't solved completely the issue. thanks for that.