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!

edhans's avatar
edhans
Community Champion
4 years ago

Without sample data it is hard to say, but make sure that no previous step automatically added any Change Type steps for that column. For example, by default, Excel will apply a type, even if it is the Any type.

Look for any previous Changed Type steps and remove it from that column, or manually change "any" to "text" early on.

Otherwise, post some 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.

  • 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!