cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Magggot
Frequent Visitor

App.powerbi not displaying all data

I have a problem like https://community.powerbi.com/t5/Desktop/App-not-displaying-all-data/td-p/2248029,

but I didn't solve it with the solution that was suggested.

what else can be done about this problem?

1 ACCEPTED SOLUTION
Magggot
Frequent Visitor

Change the connection in the model and removed IFERROR it in the measure. It works.

View solution in original post

4 REPLIES 4
Magggot
Frequent Visitor

Change the connection in the model and removed IFERROR it in the measure. It works.

MojoGene
Helper V
Helper V

In PBI Desktop, check to see if the missing data are in your tables. If the data are in the table, but not showing up in a report or visual, then there is a filter of some sort being applied. Sometimes the filter is not obvious. E.g., Do you have a date table in your table structure? Does the date table run through the current date? If for example the data table goes only to 12/31/2022, you will not see any 2023 data in your reports even though there is no obvious date filter being applied on the visual.

GilbertQ
Super User
Super User

Hi @Magggot 

 

Can you make sure that there are no hidden filters being applied on the report?

 

Typically the data is always there, sometimes there is a hidden filter or Row Level Security is being applied.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I checked everything, none of these solutions work

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors