It is the first time that I am using the web version of excel with external data sources on Sharepoint so I hope that you can help my with that.
I do have an Excel list that grabs data from an on-premise SQL server within the network using Power Query. I copied this file to Sharepoint so that several people can refresh the data and filter the columns. However, when I try to refresh the data in Excel Online, I get the following message:
"We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh..."
For me, it looks like Excel is not able to connect to the on-premise SQL server. Is there a way to use a certain gateway like in Power BI or are there any other things I could do to refresh the data online?
Thank you for your help!