App.powerbi not displaying all data

[Magggot]

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?

[Magggot · Accepted solution]

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

[MojoGene]

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]

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.

[Magggot]

I checked everything, none of these solutions work