Forum Discussion
Value for mixed data
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
Sorry for this,
let
Source = Excel.Workbook(File.Contents("..............................."), null, true),
#"Report 1_Sheet" = Source{[Item="Report 1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Report 1_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Master Customer Name (Inc)", type text}, {"Master Customer Number (Inc)", Int64.Type}, {"Incident Identifier (Inc)", Int64.Type}, {"Last WO Number (Inc)", type text}, {"Assigned To Identifier (Inc)", type text}, {"Country Code (Inc)", type text}, {"Incident Start Date Time TZ (Inc)", type datetime}, {"Incident Start Date TZ", type date}, {"Incident End Date Time TZ (Inc)", type datetime}, {"Incident End Date TZ", type date}, {"Problem Tier 1 Description (Inc)", type text}, {"Problem Tier 2 Description (Inc)", type text}, {"Problem Tier 3 Description (Inc)", type text}, {"Problem Tier 4 Description (Inc)", type text}, {"Resolution Tier 1 Description (Inc)", type text}, {"Resolution Tier 2 Description (Inc)", type text}, {"Site Postal Code (Inc)", Int64.Type}, {"Store Branch Name (Inc)", type text}, {"Total Activity Minutes (Inc)", Int64.Type}})
in
#"Changed Type"
allright
Change this piece of the code
#"Changed Type" =
Table.TransformColumnTypes(#"Promoted Headers",
{{"Master Customer Name (Inc)", type text},
to
{"Master Customer Number (Inc)", type text},
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