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!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thank you for responding,

Per your instructions, I edited the type from any to 'text' at the very beginning, but the same problem occurs. I opened the excel file, and  noticed that all columns are 'General' data type. When I changed the type to text (in Excel) the numbers that appear on the right side in that column, jumped to the left. I think the root of the problem is in Excel and how that date transfers to PBI. I would upload a sample, but I don't see an option for attachments!

 

edhans's avatar
edhans
Community Champion
4 years ago

See instructions below on sharing data.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.