Forum Discussion

Amrselim1989's avatar
Amrselim1989
Icon for Helper II rankHelper II
3 years ago

Power qury index

Dear Power Bi developers, Greetings, kinldy note i have i noticed a very strange behavior of power bi qury, i don't actully know if it power qury issue or power bi services, but let me explain ple...
Need Help
Amrselim1989's avatar
Amrselim1989
Icon for Helper II rankHelper II
3 years ago

But sir, it works fine on desktop, the problem when it's upload on the services, i believe the index is being created individualy for each table alone, that's why giving diffrenet results, is it some thing about qury folding?!

#"Added Index" = Table.AddIndexColumn(#"Grouped Rows", "Index", 1, 1, Int64.Type),
#"Renamed Columns7" = Table.RenameColumns(#"Added Index",{{"Index", "Product Type ID"}}),

 

 

 

here is where i copy and paste 

no on desktop i have same index, but on services it's going crazy?!

cassidy's avatar
cassidy
Icon for Power Participant rankPower Participant
3 years ago

I would add a Sort step before the Index, it's probably changing the order of Rows on you.