Forum Discussion
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...
Hey Amrselim1989 ,
upload your sample pbix to onedrive, Google Drive, or Dropbox and share the link.
Regards,
Tom
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?!
I would add a Sort step before the Index, it's probably changing the order of Rows on you.