Solved: Indexing issue

ld17 · ‎06-24-2022

Relatively new to Power Bi. I added an index column that I want to simply count the number of rows. In Power Query, it counts correctly, but once in Power Bi, it skips several of the first numbers in the sequence. The rows it is skipping are not blank and contain data. Below is a snippet of the issue:

Payeras_BI · ‎06-24-2022

Hi @ld17 ,

To rule out the possibility, does the issue persit when you sort by that column in PBI?

Could it be the rows are there but somewhere further down the table?

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

Payeras_BI · ‎06-24-2022

Hi @ld17 ,

To rule out the possibility, does the issue persit when you sort by that column in PBI?

Could it be the rows are there but somewhere further down the table?

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

ld17 · ‎06-24-2022

Yes, that was the issue. Thanks so much!

Indexing issue

Helpful resources

Power BI Monthly Update - November 2023

Fabric Community News unified experience

The largest Power BI and Fabric virtual conference