Forum Discussion

heidibb's avatar
heidibb
Helper IV
4 years ago
Solved

Scheduled refresh question

Hi Community,   I have a question about how power bi runs through a refresh.   Here is the general issue -- our data warehouse refreshes overnight and usually finishes before 7am. There is one jo...
Need Help
  • speedramps's avatar
    speedramps
    4 years ago

    There is a seperate Power Automate forum and lots of youtube videos.

    I suggest you start by creating a simple  Power Automate flow to do a Power BI REST API refresh then run it.

    That will trigger a dataset refresh on demand  (no need to schedule it).

     

    Then you can start adding fancy triggers to the flow. 

    I use Power Automate flows when users send daily email files I want to include in the ETL, but I dobt know what tiime it will arrive. The flow triggers when an email arrives when an agreed codeword is in the subject header, it extracts the file, does some etl, triggers the Power BI REST API refesh, copys the email to a done folder, even sends a email alert if everything was succesful or failed.   

     

    Power Automate flow  with Power BI REST API refresh are easy, dont be affraid of them. Do the free online training.


    start here https://powerautomate.microsoft.com/en-us/

     

    Please click thumbs up and accept solution buttons. Thank you 

     

speedramps's avatar
speedramps
Super User
4 years ago

Consider using Power Automate with the PBI Rest API to trogger the refresh.

It may sound really complicated but it is really easy. lost of trainign videos on youtube.

Watch this video 

Please clcik thumbs up and accept solution buttons. Thank you ðŸ˜Ž

  • heidibb's avatar
    heidibb
    Helper IV
    4 years ago

    speedramps - thank you!! the part about MS Flow might really work for our situation -- I'm sending this to someone that is much smarter than me. We have a lot of critical reports that take a long time to refresh, and if our data warehouse is running long for whatever reason, we're contributing to the slowness of an already tricky process. One question -- I saw that he(you?) went back to flow and manually hit refresh there. I'm going to explore more about this, but do you schedule flow jobs to run similarly to in the PBI service? Is it automatic?