cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shds Regular Visitor
Regular Visitor

Power BI Embedded connected to local SQL Server instead of SQL Database Azure?

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?

6 REPLIES 6
Super User IV
Super User IV

Re: Power BI Embedded connected to local SQL Server instead of SQL Database Azure?

If you do not need RLS then you could use the "Publish to Web" option, not the most secure, but simple.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

shds Regular Visitor
Regular Visitor

Re: Power BI Embedded connected to local SQL Server instead of SQL Database Azure?

hi smoupre, thanks for your prompt response. 

We do require authentication so Publish to Web wouldn't work unfortunately.

Super User IV
Super User IV

Re: Power BI Embedded connected to local SQL Server instead of SQL Database Azure?

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

shds Regular Visitor
Regular Visitor

Re: Power BI Embedded connected to local SQL Server instead of SQL Database Azure?

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.

Moderator Eric_Zhang
Moderator

Re: Power BI Embedded connected to local SQL Server instead of SQL Database Azure?

@shds

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

  1. re-fresh and re-import the pbix 
  2. Load the data from on-premises SQL Server to Azure SQL database via a regular ETL process, import a pbix in DirectQuery mode then.

 

Highlighted
shds Regular Visitor
Regular Visitor

Re: Power BI Embedded connected to local SQL Server instead of SQL Database Azure?

Hi ,thanks for your suggestion, have upvoted the idea!

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors