Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Index on two same table getting generated differently in power Bi

We have been using Index function in Power BI report. Everything is working fine  in Desktop.

 

However when we publish this report and on refreshing the report with Prod data, the values for same index are not matching.

Please see the image below. When I select Index 25, its giving me two different numbers though the source data is from same table. Source table has been imported twice in Desktop to test the index functionality.

Note: This data source has count of apprx 2 lac records.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    When we  use view from same Db as under lying Tables it work fine and when we are keeping view in different Db as underlying tables it was not forking as expected. As of nowwe kept in same Db and its working fine.

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    needs more details. Do you have ties in your rankings? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    Could  you refresh the report successfully?  Please download the pbix file to open it on the Power BI Desktop. Please refer to the following document to see if it helps you.

    Power Bi added index error? Fix with these steps 

    1. Download DriverFix (verified download file).
    2. Click Start Scan to find all problematic drivers.
    3. Click Update Drivers to get new versions and avoid system malfunctionings.

    I have also found a similar post, please refer to it to see if it helps you.

    Refresh Error in PowerBI Service. No issue refreshing in Desktop 

    • The problem lies within the Index Column formula itself. Notice that it has 5 parameters, the last one being "type int". The newer Power BI Desktop version automatically adds in the 5th parameter, which is the "type". If you remove that parameter completely, you will be able to refresh in Services. However, if you do not want to remove that parameter, you could simply update your Data Gateway to the latest version. Either one works.

     

    If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    When we  use view from same Db as under lying Tables it work fine and when we are keeping view in different Db as underlying tables it was not forking as expected. As of nowwe kept in same Db and its working fine.