Forum Discussion

NJS0303's avatar
NJS0303
Frequent Visitor
6 years ago

Columns missing from imported Excel data

Hello,   Looking for some assistance with an issue I'm having with imported Excel data.   I've got several reports linked to approximately a dozen different excel sheets and without any obvious c...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

hi NJS0303 

show us please, all source code from Advanced Editor window

NJS0303's avatar
NJS0303
Frequent Visitor
6 years ago

Hi az38 ,

 

Apologies for the delay in responding - please see below for the information requested:

 

let
    Source = SharePoint.Files("https://redacted.sharepoint.com/sites/MidlandTransfer", [ApiVersion = 15]),
    #"005-UserStructure_ITRENT-PBI xlsx_https://redacted sharepoint com/sites/MidlandTransfer/Shared Documents/ITRENT-PBI/" = Source{[Name="005-UserStructure_ITRENT-PBI.xlsx",#"Folder Path"="https://redacted.sharepoint.com/sites/MidlandTransfer/Shared Documents/ITRENT-PBI/"]}[Content],
    #"Imported Excel" = Excel.Workbook(#"005-UserStructure_ITRENT-PBI xlsx_https://redacted sharepoint com/sites/MidlandTransfer/Shared Documents/ITRENT-PBI/"),
    UserStructure_Sheet = #"Imported Excel"{[Item="UserStructure",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(UserStructure_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"User Login", type text}, {"Level3:Structure", type text}, {"Level4:Structure", type text}})
in
    #"Changed Type"

.

This example is taken from a 4 column Excel file which is imported into Power BI with the first 3 columns only.