Forum Discussion
Excel Workbook Refresh Fails in BI Service
I have seen several other replies on issues about this same topic, but nothing specifically for the problem I'm about to describe: I have several Excel workbooks that are hosted in SharePoint, ha...
I am getting the same issue!! Started May 11. Auto refresh used to work. (It worked May 10). Now I have extra work. Not happy. One of the errors mentioned something about being created in Excel 2013 and no longer supported. I rewrote workbook and made new connection with Excel 2016--same problem no refresh: on demand or scheduled.
On prem data gateway says admin has granted access for credentials.
What changed May 10/11? What is the correct way to make a connection or configure gateway now?
One Error Msg:
You can't schedule refresh for this dataset because one or more sources currently don't support refresh.
Discover Data Sources
Connection was SqlServer to Azure DB
Same on my side and no response from support on my ticket since days!