Forum Discussion
Excel Services and On-Premises SQL Data
l that you should need to do is to first, register that data source with the gateway, and then connect to it with Excel directly, as you would do normally). If the data source is registered correctly, it should "just work"
I have gained a bit of headway on this model. I now have Exel files being updated from on-premises systems via the Power BI gateway. That is a great win!
The model is, however, a bit different than I was thinking and different then what I believe is represented in this article (last option in the list) https://support.office.com/en-us/article/Use-external-data-in-workbooks-in-SharePoint-Online-8d7f5dc6-8384-4d7d-b00f-b283c1e192ef
The end goal is: Open a web page in SharePoint with a Excel Web part and click refresh data and that data will refresh on demand from an on-premises data source.
While I can get the Excel file to refresh by setting it up in Power BI and refreshing from Power BI. I still can't get the "refresh data" button in Excel Online/Excel Services Online to work. Fails everytime.
I have progressed quite a bit thanks to your help John. So thank you!
- Eric you mentioned earlier on that you are looking to avoid the power bi pro license. I thought that if you refresh via the gateway, then pro license becomes requirement?
The personal gateway does allow for refresh and scheduled. It is only daily and limited to 10K rows but it does work.
Thanks, that's good to know!
