Forum Discussion
robarivas
Post Patron
Post PatronExcel 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 ...
I am having this issue too, any ideas on how to resolve will be greatly appreciated.
robarivasPost Patron
Post PatronOne 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).