Power BI Schedule Refresh RRS feed

  • Question

  • Hello,

    I have a question that I cannot figure out. I currently have an Excel workbook pulling data from an Azure Database every 1 minute (via Power Query). While the document is open in edit mode it pulls the data successfully and updates it in the spreadsheet. Is there anyway for my excel file to constantly pull this data when its just sitting in the OneDrive? 

    Right now I'm manually saving the excel file each time I want the file to update in my OneDrive. And then I have to manually press "refresh now" in Power BI. 

    I want my Excel file to pull the data from my Azure Database every minute even when just sitting in OneDrive, automatically save the file, and then set power BI to automatic refresh. 

    When I try to enable auto refresh in Power BI it is throwing an error -- "You can't schedule a refresh because this data sources do not yet support refresh."

    Anyone have a solution to this issue or know if there is a better way to go about this that I do not know? 

    Thank you very much,


    Friday, April 10, 2015 4:06 PM


All replies