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
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.