Forum Discussion

Amrselim1989's avatar
Amrselim1989
Helper 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
Helper II
3 years ago

i know right!, so weird, in aim to find a wrok around i made the disconnect table by dax( summerizedcolumns), in aim to make sure it will use the same index it used in the power qury, i have my douts that index is running individualy even when i copy the qury, but it works fine on desktop, but on services it fore sure the index is being created individuly, should i open a tickect, this is a hug bug in power bi services?!

TomMartens's avatar
TomMartens
Super User
3 years ago

Hey Amrselim1989 ,

 

upload your sample pbix to onedrive, Google Drive, or Dropbox and share the link.

 

Regards,

Tom

  • Amrselim1989's avatar
    Amrselim1989
    Helper 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
      Power Participant
      3 years ago

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