Forum Discussion
Excel Services and On-Premises SQL Data
I should also add, because I just tested it, and it works.
An Excel workbook that is connected directly to a SQL server, and then connected to Power BI (either from OneDrive or a SharePoint library) will be able to connect to the data through the on On-Prem Data Gateway.
In short, it works. I think that I need to do a blog post on this one - there are a few intricacies involved.
Hey John, did you get around to writing that blog? ;)
We are working with a client that has an extensive powerpivot dashboard system that pulls data predominantly from a LOB on prem SQL database (syspro). The goal would be that we can connect to the same SQL database (through means that you describe in place of the current odbc connections in the power pivot data model) and refresh on schedule so outside sales team can be viewing dashboards in sharepoint with daily current data. Looking forward to your response!
Thanks! Matt@scouttg.com