Forum Discussion
Advocate IIDashboards are not refreshing
Hi googlogmob, Are you still see this issue? If so, can you file a support ticket at https://support.powerbi.com/ since may require more in depth troubleshooting. Thanks!
I'm sorry but, I am not sure this is the answer. I tries a manual refresh and no luck.
It is also worth noting that I have a scheduled refresh set up. Maybe this is the issue? Not sure. I really wish someone from the Power BI team could help.
I opened a support ticket and recieved a call back from a "support technician" with whom I relayed the problem. He did mention in the beginning of the call that there is a known issue regarding refreshing dashboards and that information has been passed to the Power BI development team. No further details were given. He attempted to trouble shoot my problem but was unsuccesful but, I am not surprised as this is a "known issue".
Either way, he had created a new ticket to assumedly escalate the situation. I will report back a solution if I get one.
Support ticket with Microsoft vanished into the ether...
I received a phone call back from one gentleman asking if I received a call from Microsoft Power BI team yet and I told him no. He had nothing additional to offer, sadly.
This morning, after rebuilding my dashboards over the weekend, I came in to find the dashboards and data sets not matching again. This is very frustrating and I am unsure of how to continue using this service!
Does anyone have any suggestions of where I should start looking?
- 4 Datasets - On Prem Gateway Refresh scheduled for 4 times a day.
- 2 Dashboards linked to said data sets.
- No fancy DAX or anything. Just standard visualizations.
What am I doing wrong?
- If you are using slicers and they are selected when you are pinning the tile , it will still applied in dashboard, at least once this happened to me. Try to pin tiles from a report with no filters and slicers. See if refreshes.
Thanks. I will check it out.
I have the reason why just not the solution... yet. (I am confident I will get there...)
Per my contact at Microsoft, there seems to be an issue with any filter more granular than a report level filter. (visual level, page level all cause problems) I have proven this issue out in the following manner:
- Using 4 datasets with matching reports and dashes.
- 3 of the 4 reports are heavily filtered and one not filtered at all.
- Simple SQL Query, Direct Query, Manually Refreshing with the PBI Data Connector.
- Fiddler trace run - No comm issues between data set and dash.
The non-filtered report/dataset is updating correctly and dash/report data matches accross all tiles. The filtered reports show the all too familiar conflicting information.
So, to suggest a "sort-of" work around, perhaps if you are able to pre-filter your result set in SQL, you could skip using the lower level filters and not have the problem. Just not the most favorable solution as it defeats a good chunk of functionality.
Microsoft PBI Team - What say you??!!??
Follow up - Bad news and worse news...
Bad news:
MS Support gentlemen I had a ticket with was transferred away from this project and my ticket was closed. Opened a new ticket with MS Support and now rehashing out the problem.
Worse news:
My theory about the filters was inaccurate. All of my dashes, with or without filters, are showing the descrepancies between the report and the dash.
Sorry for the false hope folks. I am still pushing through with MS support the best I can and will keep all posted as soon as I have some concrete solution or at least some good info.
