Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Refresh schedule for report

Hi all,

 

I have a .pbix file on my local pc which uses a connector to Exact Online in order to retrieve sales information.

I've shared this .pbix file to our workspace and with multiple colleagues. Currently I have to refresh my .pbix file in order to update the report in the workspace.

 

Is there a way to automate this? I'd like to schedule a refresh or something like that. But is there a way to do that instead of opening the file and refreshing it manually? Or would it be reccommended to place the file on a server and create a task schedule which opens the file and refreshes it..

 

Thanks in advance.

Need Help

9 Replies

  • Karljr's avatar
    Karljr
    Frequent Visitor
    5 years ago

    You need to set up a gateway.  I would suggest the enterprise gateway so your machine does not have to be on all the tiem to connect to the gateway. 

      • Karljr's avatar
        Karljr
        Frequent Visitor
        5 years ago

        yes thats what you need. 

         

        Yes system has to be up to do the refresh.  thats why I suggested the enterprise gateway not personal. 

         

        I have a sql server, SSRS in the cloud.  I put my enterprise gateway on that server so it is running all the time.  

         

         

         

         

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous,

     

    If the gateway does not support the connector you used, you can not set schedule refresh for the datasets.

    Maybe you you can try onedrive refresh.

    In this case, you need store the pbix on onedrive or sharepoints， and then get data from the pbix stored in onedrive.

    If the pbix is updated, please overwrite the pbix on onedrive, the power bi service will automatically check for updates every hour.

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks, I imported the .pbix file from OneDrive and set it to the hourly refresh. Not sure if the file itself will also do a refresh on the connector if you understand what I mean. It imports data from a software package, but I'm curious if the OneDrive refresh only refreshes the current data in the .pbix and won't let the connector refresh.

      • v-xulin-mstf's avatar
        v-xulin-mstf
        Community Support
        5 years ago

        Hi Anonymous,

         

        It doesn't refresh the connector, it only refreshes the latest data of the pbix file in onedrive.
        In your case, you need to overwrite the pbix file manually to achieve the effect of refreshing, automatic refreshing is not supported currently in Power BI.

        If you still have some question, please don't hesitate to let me known.‌‌

         

        Best Regards,

        Link

         

        Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!