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

     

LuteceFalco's avatar
LuteceFalco
Helper II
9 years ago

let
Source = #"Report 1",
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
  #"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"Master Customer Name (Inc)", "Master Customer Number (Inc)", "Incident Identifier (Inc)", "Last WO Number (Inc)", "Assigned To Identifier (Inc)", "Country Code (Inc)", "Incident Start Date Time TZ (Inc)", "Incident Start Date TZ", "Incident End Date Time TZ (Inc)", "Incident End Date TZ", "Problem Tier 1 Description (Inc)", "Problem Tier 2 Description (Inc)", "Problem Tier 3 Description (Inc)", "Problem Tier 4 Description (Inc)", "Resolution Tier 1 Description (Inc)", "Resolution Tier 2 Description (Inc)", "Site Postal Code (Inc)", "Store Branch Name (Inc)", "Total Activity Minutes (Inc)"}),
#"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "Master Customer Name (Inc)", "Master Customer Number (Inc)", "Incident Identifier (Inc)", "Last WO Number (Inc)", "Assigned To Identifier (Inc)", "Country Code (Inc)", "Incident Start Date Time TZ (Inc)", "Incident Start Date TZ", "Incident End Date Time TZ (Inc)", "Incident End Date TZ", "Problem Tier 1 Description (Inc)", "Problem Tier 2 Description (Inc)", "Problem Tier 3 Description (Inc)", "Problem Tier 4 Description (Inc)", "Resolution Tier 1 Description (Inc)", "Resolution Tier 2 Description (Inc)", "Site Postal Code (Inc)", "Store Branch Name (Inc)", "Total Activity Minutes (Inc)"})
in
  #"Reordered Columns"

Anonymous's avatar
Anonymous
Not applicable
9 years ago

ok. that's the code of the error report.

 I need in addition the code of the original "Report1".