- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 please, i have in power qury table of products
Product | Type |
A | Global |
B | Local |
C | international |
now i wen to add an index to use it as product type index, so iused the index button in power qury and now i have below:
Product | Type | Index ID(Product Type ID) |
A | Global | 1 |
B | Local | 2 |
C | international | 3 |
so far so fine, so i finished my calculations and now i want to make a copy table of the product to use as a disconnected table,
so i copy and past the final power qury table product and removed all columns except product and Index ID(Product Type ID) to be like this,
Product | Index ID(Product Type ID) |
A | 1 |
B | 2 |
C | 3 |
when i load on desktop the Index ID(Product Type ID) is working fine as A is 1 in both tables, B is two in both tables, and so on, but when i publish to the services (power bi services), every thing get missed up, so the A in one table is 1 and in the other table 2
b in the first table is 3 and the other is 4, how is that possiable, it works fine on the desktop, but when publish to the services it the index is changed and works diffrenlty, how is that possiable they are coming from same table source?!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.
Proud to be a Microsoft Fabric Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hey @Amrselim1989 ,
upload your sample pbix to onedrive, Google Drive, or Dropbox and share the link.
Regards,
Tom
Did I answer your question? Mark my post as a solution, this will help others!
Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would add a Sort step before the Index, it's probably changing the order of Rows on you.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
07-24-2024 01:42 AM | |||
08-05-2024 11:01 AM | |||
01-16-2024 03:12 PM | |||
01-16-2024 02:34 AM | |||
02-28-2023 05:38 AM |
User | Count |
---|---|
18 | |
15 | |
13 | |
8 | |
8 |