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
jennratten's avatar
jennratten
Super User
3 years ago

Hello - the same values should be observed in Power BI desktop and when published online unless there are other filters in one that are not in the other, or if the data is refreshed in one and not the other.  

  • 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?!