Skip to main content

    Power BI

    Needs Votes

    Evaluate Excel Cell properties in Power Query of when importing Excel files

    Vote (1) Share
    Dipak Bhudia's profile image

    Dipak Bhudia on 13 Jun 2020 03:15:44

    Excel is one of the most widely imported datasources. Table sections a often broken up by a Bold font/ /spaces or tab within the cell for grouping. All this valuable information is lost when importing data from excel into Power Query. It is virtually impossible to import some grouped data without hardcoding all sections through custom transformations, something we would all love to avoid.

    if [myColumn].CellProperties('Font-style') = "Bold", true, false