cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Dashboard report not showing all data

I have noticed on several dashboard items that this does not get updated properly when the page that the visual is pinned from has on page slicers.

 

I have seen this behaviour occur on several visuals and seem to do one of two things, either not update at all with data from the recent dates so it appears "frozen" or partially updates based on no logical set of parameters!

 

Is this a known issue or expected behaviour, or does this only happen when a report is perhaps too complex or too large? I have tried several approaches but the only one that seems to work is to remove all on page slicers or create a duplcate of the page/visual for a version without the slicers present.

 

From the screenshots below, the first one is from the dashboard item. The second is of the same visual but opened in the report view. There should be over 100 lines for the date of the 15/01/2018 however the vast majority seem to be truncated in the dashboard view

 

Thanks

Martin

 

 

 pbidash.pngpbi report view.png

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Dashboard report not showing all data

Could be an issue. However, with Dashboards (not Reports), the issue is often caused because dashboard tiles retain the exact filters and slicer settings at the time of pinning the tile.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Helper I
Helper I

Re: Dashboard report not showing all data

So potentially if I have a date slice on the page, then this could be the cause? I have one that is a between x & y dates which may be the culprit.

 

The only problem with this though is that it is showing things from the current date, just not all of them and there isnt any obvious thing in common with those that are or are not shown!

 

Highlighted
Regular Visitor

Re: Dashboard report not showing all data

I had the same issue and I found that a different visual was drilled down, and this afffected everything else.

Highlighted
Regular Visitor

Re: Dashboard report not showing all data

@Greg_Deckler You are a life saver! I had RLS filter enabled for x when I pinned tiles to dashboard.I was looking at with RLS filter y and was pulling my hair out why I was not seeing any data on dashboard where reports were working fine.

Highlighted
Super User IV
Super User IV

Re: Dashboard report not showing all data

Yeah, that one will drive you insane... 🙂

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021