A confirmation code will be emailed when setting up your account or resetting your password—check spam if needed.no-reply@dynamicscommunities.com

Automated Refresh

  • Power Platform

    Automated Refresh

    Posted by DSC Communities on January 15, 2018 at 10:57 pm

    • Andrew Lim

      Member

      January 15, 2018 at 10:57 PM

      PowerBI can :

      • schedule 8 refreshes per day (current limitation)
      • get users to click on the refresh button
      • get users to exist the dashboard/report and redeploy the same dashboard/report 

      The problem statement – users looking at the dashboard/report requires it to automatically refresh without any human intervention. This is a bigger issue when the dashboard/report is on smart devices as the buttons are a lot smaller.

      A solution to overcome this is to use SharePoint and JavaScript to trigger the refresh, but this would open up potential JS vulnerabilities and having to use another application, SharePoint.

      Have anyone found a solution whereby they are able to refresh the dashboard/report seamlessly?

      ——————————
      andrew lim
      head of data
      webjet
      Melbourne VI
      98289583
      ——————————

    • Johnny Winter

      Member

      January 16, 2018 at 3:45 AM

      A direct connection to an Analysis Services cube is the way I’ve overcome this, though I suspect that’s not the answer you’re looking for.

      ——————————
      Johnny Winter
      Business Intelligence Developer
      AO
      Preston
      07715414547
      ——————————
      ——————————————-

    • Andrew Lim

      Member

      January 17, 2018 at 4:07 PM

      Thanks Johnny, our reports are connected to SSAS. The issue is the PBI refresh ie the UI, not the data refresh at the back end. We have a report/dashboard that shows our live activities where SSAS is being updated every 5 mins. When SSAS is refreshed, PBI does not automatically reflect the data changes.

      ——————————
      andrew lim
      head of data
      Webjet
      Melbourne VI
      98289583
      ——————————
      ——————————————-

    • Johnny Winter

      Member

      January 18, 2018 at 3:20 AM

      Ah… you have the same set up as us then. Yep, we’re using a Chrome plug-in too, as mentioned below.

      You’re right though – seems daft that there isn’t just out of the box functionality. It means PBI loses it’s appeal as a dashboarding tool

      ——————————
      Johnny Winter
      Business Intelligence Developer
      ——————————
      ——————————————-

    • Simon Hill

      Member

      January 16, 2018 at 7:50 AM

      ?Depending on the data source, Power BI can refresh at 15 minute intervals automatically. Hard to see an argument for more frequent refreshes. If you need frequent refreshes, I’d see what I could do with the source before I considered ‘3rd party’ solutions.

      ——————————
      Simon Hill
      Manager
      TTX Company
      Solihull
      ——————————
      ——————————————-

    • Brent Pearce

      Member

      January 16, 2018 at 9:57 AM

      I am a huge fan of the Power Update product. Unlimited refresh is one of many reasons. Find them here.

      ——————————
      PentaGalDad
      ——————————
      ——————————————-

    • Simon Hill

      Member

      January 18, 2018 at 5:56 AM

      ?I appreciate your intent here, but buying another product after already purchasing Power BI is not an ideal solution. And many organisations would have concerns about an application like Power Update because of its security implications.

      The ideal solution is find a way to set up the dashboards where DirectQuery would work. Then you’d have the capability to use Power BI itself to refresh every 15 minutes without intervention by users or a 3rd party app. Anyone seriously need refreshes more often than 15 minutes?

      ——————————
      Simon Hill
      Manager
      TTX Company
      Solihull
      ——————————
      ——————————————-

    • Audrey Abbey

      Member

      January 16, 2018 at 11:31 AM

      Are you talking about refreshing the data model?
      Or having the visuals update after the data model is refreshed?

      Those are two separate actions. 
      The former situation is pretty well covered by previous posters.
      8 Refreshes a day is only a limit for on-premises data that is connected via the Gateway. If your data is in the cloud, or if you are using direct query, then other rules apply. 

      If the latter, you can try using one of the browser plug ins that refreshes the page on a timer. 

      Best, 
      Audrey

      ——————————
      Audrey Abbey
      SR. BI Developer/Analyst
      New Seasons Market
      307-840-1825
      ——————————
      ——————————————-

    • Andrew Lim

      Member

      January 17, 2018 at 4:12 PM

      Thanks Audrey, it is the later, ie having the visuals update after the data model is refreshed. The closest we have is using Chrome plug in to refresh the report, which adds complexity. We were hoping that MS would have something out of the box in their arsenal of widgets.

      ——————————
      andrew lim
      head of data
      Webjet
      Melbourne VI
      98289583
      ——————————
      ——————————————-

    • Audrey Abbey

      Member

      January 19, 2018 at 9:53 AM

      Not that I am aware of. 
      Might be a good thing to suggest for Power BI ideas!
      Most of the time, I see this request related to displaying Power BI dashboards up on a sales or factory floor, where people are just passive observers. 
      Maybe they can add a “Display” setting that will ensure a refresh. 

      Power BI is focused on self-service, so it makes sense that they assume a user is actively participating. 

      Good luck!
      Audrey

      ——————————
      Audrey Abbey
      SR. BI Developer/Analyst
      New Seasons Market
      307-840-1825
      ——————————
      ——————————————-

    • Mike Hammons

      Member

      January 22, 2018 at 10:30 AM

      Hi Andrew,

      Would real time streaming be an option for this? It might require a little bit of coding with the Power BI SDK.

      Real-time streaming in Power BI – Power BI

      Microsoft remove preview
      Real-time streaming in Power BI – Power BI
      With Power BI real-time streaming, you can stream data and update dashboards in real-time. Any visual or dashboard that can be created in Power BI can also be created to display and update real-time data and visuals.
      View this on Microsoft >

      ——————————
      Mike Hammons
      Director, Business Intelligence
      AKA Enterprise Solutions
      Woodstock GA
      770-926-5020
      ——————————
      ——————————————-

    • Simon Hill

      Member

      January 22, 2018 at 10:52 AM

      ?I looked into real time streaming and it’s entirely data source dependent. If you don’t have the right source type (Push etc.) then its not usable.

      That’s not to say, of course, you couldn’t develop an intermediary application to fetch the data form the source and push it out to PBI. But that’s a question of development and support cost. If you don’t actually need real-time updates, getting the data via DirectQuery is probably the most cost effective solution, if feasible.

      Or you could look at it the other way, if your data can’t push real time updates and can’t be accessed using DirectQuery, then what makes the updates so urgent?

      ——————————
      Simon Hill
      Manager
      TTX Company
      Solihull
      ——————————
      ——————————————-

    • Andrew Lim

      Member

      January 22, 2018 at 10:04 PM

      Hi Simon,

      The issue is not at the backend, ie Data Mark, Tabular, etc. It is to do with how the front end visualisation tool, it cannot refresh seamlessly without human intervention.

      I have since spoken with Microsoft and this is now in their ideas backlog. Waiting on a timeline from Microsoft.

      Regards,
      Andrew

      ——————————
      andrew lim
      head of data
      Webjet
      Melbourne VI
      98289583
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 8 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Automated Refresh’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .

Welcome to our new site!

Here you will find a wealth of information created for people  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!