Forum Discussion
Memorable Memberdashboard not updating
I built a simple PBI model as a demonstration. Excel table to PBI desktop, desktop to PBI web and PBI web to OS app.
The problem I have is the couple of charts I built and pinned to the dashboard change in the reports section based on the slicers (date) but those changes do not flow through to the actual dashboard. This seems an unlikely limitation. I am running a full but free test version of PBI which may well be the issue but need to check it out as I am meant to make a organisational wide reccomendation.
Oh wow, that would be a massive problem. Why would you want a mobile dashboard that needed to be manually rebuilt each refresh period?
good to hear its a problem to be solved rather than a limitation. i might try a complete rebuild and see if that fixes things <sigh>
14 Replies
- Greg_Deckler
Community Champion
I *believe* from my testing that the Dashboard is kind of independent from the Reports so, no, clicking some slicers on a report is not going to change the dashboard. The dashboard will display the visualization as it existed at the time it was pinned in terms of slicer selections etc. but it will not dynamically change. In fact, in my experience while it shows on the dashboard as of the "point in time it was pinned", if you click it, it will go back to the report by default without the correct slicers selected, they appear as the report default selections (at time of upload). :(
Somebody correct me if I am completely off-base and wrong here.
samdthompsonOh wow, that would be a massive problem. Why would you want a mobile dashboard that needed to be manually rebuilt each refresh period?
- Greg_Deckler
Well, the dashboard will reflect current data but not changes to a report. So, if you update your data, the dashboard will reflect that in the context of the visualization at the time of pinning.
dgelfusoHelper I
In order to have dashboard update automatically, the entire report must be pinned to the dashboard. If only a portion of a report is pinned to the dashboard, it will be static.
- Greg_DecklerOooooohhhhhh... light bulb. I'll have to check that one!! That certainly does not sound right!
- samdthompson
would appreciate that.
- Greg_Deckler
OK, here's what I did. I created a new PBIX file and loaded it to the system creating a data set, report and dashboard. Basically I had a list of "facilities". In the report, I added 2 visualizations, a simple table list of facilities (157 of them) and also a count of facilities (157) and pinned these to my dashboard. The data came from a CSV file. So, after uploading it, I added a facility to my list, now 158 of them. I refreshed and saved my PBIX file. First, I tried to refresh my data source but that failed miserably because I think there are still some bugs to be worked out there. So, then I just uploaded and overwrote my PBIX file. My report updated and my dashboard count updated. Note that my other visualization in my dashboard did not update because I had it filtered via a slicer to only 12 facilities when I pinned it.
I'm thinking that perhaps it is a particular combination of your visualization that is not causing it to show as updated? If you are slicing data and then pinning it and your new data falls outside of the current slicer, I don't think that your data in your dashboard will update, because the dashboard pinned visualization maintains the "context" of when it was pinned. But, if your dashboard visualization does NOT have any filters or context, like my simple "count" of facilities, then the visualization will reflect the new and current data.
I think that this state of affairs makes a lot of sense personally but I can see as how it may not act as one might expect.
I have also noticed that pinned visualizations seem to be constrained to their size on the dashboard. For example, I removed all of my slicer filters and pinned the facilities table to the dashboard. It only displayed the first 13. However, if I expanded it, it displayed more. In no case did it provide a scroll bar. I find this situation much less logical and consider this to be a bit of a bug IMHO. I should get a scroll bar.
Does any of this help?
