Forum Discussion

robarivas's avatar
robarivas
Post Patron
7 years ago

Excel Workbook OneDrive Refresh

I have a few Excel workbooks published to a Power BI workspace which reside on a OneDrive for Business / Sharepoint folder. They are scheduled to refresh daily (via an Enterprise gateway). Every day ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Same issue for me on Sunday 5/5/2019.  Please advise

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am having this issue too, any ideas on how to resolve will be greatly appreciated. 

    • robarivas's avatar
      robarivas
      Post Patron
      7 years ago

      One or more of the following 3 things fixed the problem for me:

       

      1) Addressing any Formula Firewall errors that may exist in your queries.

      2) Completely removing the workbook from the Power BI Service and then reconnecting it back in

      3) Eliminate any queries that reference worksheets within the same workbook. (So move that sheet to a different workbook if you need the query).