Forum Discussion
cannot see data in visual
I can see the data in the Table in the query, however when i build the visual using the same table, I do not see the full population of data in the visual. any idea why?
Hello radhikab84,
Could you confirm whether your query has been resolved with the solutions provided, or if the issue still persists? If you need further assistance, please share sample data that clearly demonstrates the problem you’re facing.- Include a small dataset that accurately represents the issue (ideally in a table format or as a downloadable file, rather than a screenshot).
- Make sure not to include any sensitive or unrelated information.
- Please also provide the expected result based on your sample data.
If you need help preparing or uploading sample data, you can consult this guide:
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityThis information will help us accurately reproduce your scenario.
Best regards,
Ganesh Singamshetty.
5 Replies
Hi radhikab84 ,
What do you mean by you don't see the full population of data?
When adding columns to a table visualization you must be carefull with the aggregations (SUM, AVERAGE, FIRST, LAST) that you can change for each of the fields selected bu you also need to be carefull with the data itself so for example if you have two rows that are exactly the same values even if you don't summarize any values they will show only has one row.
See the example below:
Has you can see I have six rows on the table but on the visual only five show up because the engine treats the same values has a single value for optimization and performance.
This can be clear in the image below were I do a count of the rows for each value
my values are unique and no aggregations are required or have been sleceted.
What is the size of your data? how many rows and columns do you have?
Why do you want to see the full data on your visualization?
Hello radhikab84,
Could you confirm whether your query has been resolved with the solutions provided, or if the issue still persists? If you need further assistance, please share sample data that clearly demonstrates the problem you’re facing.- Include a small dataset that accurately represents the issue (ideally in a table format or as a downloadable file, rather than a screenshot).
- Make sure not to include any sensitive or unrelated information.
- Please also provide the expected result based on your sample data.
If you need help preparing or uploading sample data, you can consult this guide:
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityThis information will help us accurately reproduce your scenario.
Best regards,
Ganesh Singamshetty.Hello radhikab84,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
