Share via

Checkboxes missing in power query Excel 2016

Anonymous
2023-01-20T12:54:40+00:00

Hello Community,

Some checkboxes (Column distribution, Column profile and Column quality as shown in the images below) are missing under the "View" tab in my Power Query Editor when I try to "Get & Transform" a table from Excel 2016 and have tried Googling this issue but unfortunately couldn't find a solution. I was hoping to find an answer here.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. Anonymous
    2023-01-20T17:53:07+00:00

    Greetings I am Leon. What excel version was that on your first image? Possibly due to differences in their versions.

    Hello Leon,

    I am not sure about the version in the first image since it is from a tutorial on youtube. Perhaps it is excel 365.

    I am using 2016. Are you trying to say that 2016 does not have those checkboxes?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-01-20T16:58:04+00:00

    Greetings I am Leon.

    What excel version was that on your first image?

    Possibly due to differences in their versions.

    0 comments No comments
  3. Anonymous
    2023-01-20T15:52:41+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.

    Not a problem here.

    Share files.

    https://www.mediafire.com/file/cy5mnjgymud32mc/01_20_23.xlsx/file

    https://www.mediafire.com/file/r8c8abfdrq8m63h/01_20_23.pdf/file

    0 comments No comments