Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
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?
So far, there's no gateway or refresh feature in Power BI Embedded, you can vote this idea up.
As a workaround using Power BI, you can either choose
Hi ,thanks for your suggestion, have upvoted the idea!
If you do not need RLS then you could use the "Publish to Web" option, not the most secure, but simple.
hi smoupre, thanks for your prompt response.
We do require authentication so Publish to Web wouldn't work unfortunately.
You do have the option of using something like Pyramid Analytics Server to publish your Desktop reports to locally. Similar functionality is on the roadmap for SQL Server Reporting Services.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
29 | |
3 | |
3 | |
2 | |
2 |