title: Automatic hourly refresh of a Power BI dataset from an Excel file stored on OneDrive
body: <p>How to set up automatic hourly refresh of a Power BI dataset from an Excel file stored on OneDrive for Business? What am I doing wrong?</p>
  <p>My set up goes the following path on the map of possible connections described by Vesa Tikkanen in the post <a href="https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=44" rel="nofollow noreferrer">Power BI: Why my report is not refreshing from OneDrive? Compatibility chart for sources.</a></p>
  <p><a href="https://i.stack.imgur.com/NNivT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NNivT.png" alt="enter image description here" /></a>
  Original image comes from: <a href="https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=44" rel="nofollow noreferrer">https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=44</a></p>
  <p>Manual refresh of a dataset works correctly as shown on the picture below but hourly refresh does not even start.</p>
  <p><a href="https://i.stack.imgur.com/BcXkem.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BcXkem.png" alt="enter image description here" /></a></p>
  <p>I try to set up automatic hourly refresh by choosing 1 and then 3 &quot;Schedule refresh&quot;. I have OneDrive refresh set up for ON. It should be sufficient. Should anything else be enabled? Should &quot;Scheduled refresh&quot; be enabled?</p>
  <p><a href="https://i.stack.imgur.com/sD9kg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sD9kg.png" alt="enter image description here" /></a></p>
  <p>For sure I have good &quot;Data source credentials&quot;, because manual refresh works. My PBIX file is also stored on OneDrive so it does not require &quot;Publishing&quot; for PBIX update.</p>
  <p>I have sourced my Excel file just like it has been presented in this tutorial: <a href="https://youtu.be/uxMlV9KKf6E?t=315" rel="nofollow noreferrer">https://youtu.be/uxMlV9KKf6E?t=315</a></p>