I am looking into ways to most efficiently provide our customer data to those customers and we are focusing on PowerBI. However, it would be too much of a hassle to have our customers sign up for a PowerBI.com account so they can see reports in the cloud.
The next option would be to make use of Power BI Embedded, but from what I am reading in the documentation it seems that the only way to connect your report to a (live) database would be via a populated SQL Database on Azure. Is it possible to use Power BI Embedded in combination with our local SQL Server, just like we are now using the On-premises Data Gateway?
And if not, what other ways would there be to use PowerBI to present our customers with their own data in interactive charts/reports?
We looked into Pyramid Analytics, but that's not a great match in terms of added functionality and price. Do you have some more information about the SSRS option? This sounds like something we could use.