Forum Discussion

googlogmob's avatar
googlogmob
Advocate II
10 years ago
Solved

Dashboards are not refreshing

The problem is that dashboard tiles are not refreshing, whereas the report connected to the dashboard is updating properly according to the set schedule. This problem became very frequent about a we...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

We have a report designed in PowerBI Deskptop that has a period filter in order the limit YTD comparisons for this year against last year. At the end of each period this filter is updated to reflect the new period and is published, overriding the existing reports. Everything has worked fine as the URL remains the same so links are not broken

 

I've now looked to build dashboards to reflect this updated data, but when the report is updated the dashboards are not. Why do dashboards on PowerBI have such a fundamental flaw? Is there a workaround?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Exeperiencing exactly same issue and following the topic for any potential solution. 

 

regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Anonymous As you liked my post I assume your problem is similar to mine (A change in period filters not being reflected in dashbaords). 

     

     

    My solution was to have a hidden page with visualisations specifically made to be used in the dashboards. Instead of using a slicer to update the period for YTD calculations I used a calculated column (named current period) on my period definition date table using the logic is DATE FIELD <= TODAY() to indicate all the dates before or equal today (returning TRUE or FALSE). Then I filtered all my measures for the dashboard by using IS PERIOD <= Max(Period where 'current period' = TRUE and Financial year = 'this year')

    • PowerBI_Lamer's avatar
      PowerBI_Lamer
      Frequent Visitor
      6 years ago
      Anonymous wrote:

      My solution was to have a hidden page with visualisations specifically made to be used in the dashboards. Instead of using a slicer to update the period for YTD calculations I used a calculated column...

      What do you mean by hidden page?

       

      I am considering to build separate report on the same underlying data, with no slicers or filters, and just prepare measures like "show last 10 days" or something, and then pin visuals based on this measure (perhaps not measure but table/query on underlying data) to dashboard. Is your workarround the same idea?

       

      I think there might be another solution for this: Tableau or QlikView.

      For microsoft PowerBI seems not the core business, so they don't give a F about 5 years old issues. I wonder if other BI service suppliers share the same approach.