Forum Discussion

byronf's avatar
byronf
Frequent Visitor
5 years ago

Text case in being changed automatically

Power BI is changing the format of my data when I import it, by auto capitalizing certain text values. In the picture below (from the Power Query Editor) you can see that the column called "Master...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

byronf Can you post your code from Advanced Editor?

  • byronf's avatar
    byronf
    Frequent Visitor
    5 years ago

    Hi Greg_Deckler 

    Sure

    let
    Source = Salesforce.Data(),
    CPA_Costing__c = Source{[Name="CPA_Costing__c"]}[Data],
    #"Filtered Rows" = Table.SelectRows(CPA_Costing__c, each ([RecordTypeId] = "0120Y000000ytNlQAI")),
    #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Id", "Name", "CPA_v2_0__c", "Amount__c", "Applied_to__c", "Condition__c", "Conditional_value__c", "Cost_Type__c", "Rate__c", "Shipment_Order_Old__c"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"Shipment_Order_Old__c", "SO_id"}, {"CPA_v2_0__c", "CPA_id"}, {"Name", "Master Costing Name"}})
    in
    #"Renamed Columns"