Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Not all data is being displayed in table

Hello, 
I am starting my work with power bi, and first issue i had met is that not all data from dataset is being displayed.

I had imported data from table, choosing import in connection settings.

As a result i had get all data from DB:
Przechwytywanie.PNG

then i had created simple report only with table in it. But whatever columns i would choose there are only some rows being displayed:

id.pngPrzechwytywanie.PNG

 

As i understand the data should not depend on selected columns. 

 

I had of course refreshed data from data set, checked if any filters are active, checked after rightclick display all data, and so on.

Thanks in advance.

1 ACCEPTED SOLUTION
AC_DATA
Frequent Visitor

Your "Id" column is possibly being summarized on the table. Try clicking the dropdown on the Id field in the Values section of the table and select "Don't summarize".

 

PBI.png

View solution in original post

3 REPLIES 3
venriquez
Regular Visitor

In desktop as you can see in Power Query Editor all the data is there. 

venriquez_0-1754597060431.png

But when I close it and go to table view the percent column is blank. I can create visuals and the data shows up, but why won't it show in table view?

venriquez_1-1754597147823.png

It only does it with this one dashboard. I have tried recreating in a new Power BI, it does the same thing. 

 

AC_DATA
Frequent Visitor

Your "Id" column is possibly being summarized on the table. Try clicking the dropdown on the Id field in the Values section of the table and select "Don't summarize".

 

PBI.png

Anonymous
Not applicable

Thank you very much for help, i think i had tried this, but it needs to be checked on all columns. Now it works.

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors