Forum Discussion

Vivo's avatar
Vivo
Regular Visitor
8 months ago
Solved

missing data

when I do a query in my database I get 13 records. when I do same query in Power BI, I get 12. Can someone help in why that is
happening? How can I fix it?

  • Ah ok got it. Then this might be due to implicit GROUP BY in Power BI: If you're using a visual (like a table) without all columns, Power BI automatically aggregates duplicate rows. Check if "Don't summarize" is set for all columns.

15 Replies

  • Hi Vivo,

     

    may I ask you to share a bit more information to help you out?

    Which database (on-prem, cloud, SQL, no-sql,...)?

    With which tool have you queried the database?

    With which query and how have you queried the DB from PBI?

     

    Best regards!

    • Vivo's avatar
      Vivo
      Regular Visitor

      Hello, I'm using an Oracle database and Power BI desktop for my report. 

      • Mauro89's avatar
        Mauro89
        Icon for Super User rankSuper User

        Vivo is suggest looking at the actual records (as they are a handy number) and check out which one is the record missing and if this record is somehow "suspicious". If there is no filter or any Power Query transformation done which hinders the record to not be there it needs to be checked further.

         

        Best regards!

  • Vivo's avatar
    Vivo
    Regular Visitor

    Hello, 

    I'm using an Oracle database. and created the report in Power BI desktop.

    • Vivo's avatar
      Vivo
      Regular Visitor

      I look, no filter is applied.

      • v-echaithra's avatar
        v-echaithra
        Icon for Community Support rankCommunity Support

        Hi Vivo ,

        Check the visual settings:

        Go to your table visual in Power BI.
        For each column, click the dropdown arrow and select “Don’t summarize”.
        This tells Power BI to display each row exactly as it is without aggregating.

        Check Power Query steps:
        Open Transform Data → Power Query Editor.
        Make sure no “Remove Duplicates” or filters were applied accidentally.
        If needed, load all columns to maintain uniqueness.

        Verify by adding an index column

        In Power Query, you can add an Index Column to ensure each row is unique for visuals.
        This guarantees that even fully identical rows are displayed separately.

        If you still can't resolve the issue, please provide the sample Pbix file. How to provide sample data in the Power BI Forum

        You can refer the following link to upload the file to the community.
        How to upload PBI in Community

        We are available to support you and are committed to helping you reach a resolution.

        Best Regards,
        Chaithra E.

  • v-echaithra's avatar
    v-echaithra
    Icon for Community Support rankCommunity Support

    Hi Vivo ,

    I just wanted to check if the issue has been resolved on your end, or if you require any further assistance. Please feel free to let us know, we’re happy to help!


    Thank you 
    Chaithra E.

     

  • v-echaithra's avatar
    v-echaithra
    Icon for Community Support rankCommunity Support

    Hi Vivo ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.