Forum Discussion

LuteceFalco's avatar
LuteceFalco
Helper II
9 years ago
Solved

Value for mixed data

Hi all,   In one of our column, we have mixed data with numbers and text, example: AH34839, and in the same column we have only rows with numbers, exemple: 41774230 so when we try to import this Ex...
Need Help
  • LuteceFalco's avatar
    LuteceFalco
    9 years ago

    I found how to make that it's working. Maybe it's the same thing like you wrote me, but I'm glad that it's working well for me.

     

    In Advanced Editor, "{{"Master Customer Name (Inc)", type text}" I replace "text type" by "general", same option for data type that you can find in Excel, but not in PBI.

    So, when I pressed save, it's give me an error code, but at this moment I press on remove "changed type", and this is what's changing my data type in ANY, what I need actualy, it's same as general in Excel. So, I tested it, and it's show me now in my table all informations, even in filter, when I press now "Load More" it's show me all what I need.

     

    Thanks a lot Anonymous

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

allright

 

Change this piece of the code

    #"Changed Type" =
        Table.TransformColumnTypes(#"Promoted Headers",
        {{"Master Customer Name (Inc)", type text},

Spoiler
        {"Master Customer Number (Inc)", Int64.Type},

      

 

 

to

{"Master Customer Number (Inc)", type text},

 

 

LuteceFalco's avatar
LuteceFalco
Helper II
9 years ago

I found how to make that it's working. Maybe it's the same thing like you wrote me, but I'm glad that it's working well for me.

 

In Advanced Editor, "{{"Master Customer Name (Inc)", type text}" I replace "text type" by "general", same option for data type that you can find in Excel, but not in PBI.

So, when I pressed save, it's give me an error code, but at this moment I press on remove "changed type", and this is what's changing my data type in ANY, what I need actualy, it's same as general in Excel. So, I tested it, and it's show me now in my table all informations, even in filter, when I press now "Load More" it's show me all what I need.

 

Thanks a lot Anonymous