Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Refreshing dashboards in Power BI Service

Hello,   I work on Power BI dashboards based on Fresh Service datas. The Fresh Service option I use provides me with hourly .csv files, but I could not refresh the data and the table automatically ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    Please try to create a Desktop flow with  Power Automate. Simulates manually clicking the refresh button and opening the report

    For more details, you can read related document: Create a Power Automate desktop flow - Power Automate | Microsoft Learn

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

Please try to create a flow by Power Automate.

The flow steps:

1. according to your demands to refresh the dataset to get the new data

2. when refresh complete, open the report in web browser

 

For more details, you can read related document: How To Use Power Automate To Refresh Data In Power BI (enterprisedna.co)

Thanks for your efforts & time in advance.

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Binbin Yu,


    Thank you very much for your answer. I followed this tutorial as you advised, but I am not sure if this is what I am looking to do.


    Power Automate allows me to create a flow that is connected to a button, but the goal is that the dashboard reloads without human intervention. Eventually, the dashboard should be displayed on a screen, on a wall, and nobody should have to touch it, so I can't afford to create a button to reload (even if I admit it would probably be easier and faster X)). And I didn't find in the Power Automate settings on Power BI Desktop an option to automate the operation, but maybe I missed it.


    I also have another question. Even after making the button, when trying to run it, I get an error. I received an email from [email protected] telling me "1 of your flow(s) have failed" and I see on make.powerautomate.com (where I am redirected by going to flow.microsoft.com) that my last calls are failing. Looking at the video at the end of the article, I see that the reloads with Power Automate count towards the 8 daily refreshes provided by Power BI Pro, or 48 with Power BI Premium. I already have 8 refreshes set up on Power BI Service (even though they are supposed to occur later in the day, I guess the loads are "saved" to be properly honored ?), which is probably why I have failures ; however, having a Premium license per user, shouldn't I have 48 refreshes per day ? Of course, I am using the right account, not a second one or anything else. If you have the answer to this, I'm also interested ^^'>

    Anyway, I thank you very much for the time you have already spent on me, hoping you have the answer to my problems ^^'>

    I will continue to try to solve it on my side, of course.

     

    Best regards,

    Horus

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Anonymous ,

      According to your descriptions, i think you have set the schedule refresh rule in Power BI Service, the number of times this type of refresh is limited, please try to use the common refresh, this type of refresh has no limits.

       

       

      Best regards,
      Community Support Team_ Binbin Yu
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hello again,

         

        I'm really sorry but I can't see or make work what you are talking about 😕


        I don't see any additional settings I missed in the Power Automate configuration on Power BI Desktop and even after disabling all the automatic refreshes of the day and waiting for Fresh Service to send me the new data (I have a copy of my file, one serves as a test and the other as a witness), the button doesn't seem to work since the table doesn't update after activation. Even when clicking on "Refresh visuals" or reloading the page. I add that I didn't had to enter the link and identifiers to download the datas, as they come from a website, to configure the Power Automate.


        make.powerautomate.com shows me various successes and failures, but even in the case of successes the table is not updated.


        So I don't know what to do X)

         

        Thanks again for taking your time to help me, I'm not very smart ^^'>

         

        (Tell me also if I'm in the right forum, at first I was on Desktop but following the advice of a user, I understood that I had to use the automatic refreshes on Service and I changed forum. Now I don't really know where I'm supposed to be and I get confused X))