PowerBI Embedded: Using Local SQL Database instead of Azure Sql... possible?

[Soup]

Hi, 

So I'm simply trying to find out whether or not its possible to use a local SQL database to pull and refresh a dataset. The only options I've seen so far are:

- Azure hosted SQL Database. 

- The On-premises Data Gateway (which as far as I can see steams the local db to the cloud.)

Both options seem innappropriate for my situation. I really dont want to assign online DB resources or put further strain on the network. 

Thanks

[Eric_Zhang · Accepted solution]

---

@Soup wrote:

Hi, 

So I'm simply trying to find out whether or not its possible to use a local SQL database to pull and refresh a dataset. The only options I've seen so far are:

- Azure hosted SQL Database. 

- The On-premises Data Gateway (which as far as I can see steams the local db to the cloud.)

Both options seem innappropriate for my situation. I really dont want to assign online DB resources or put further strain on the network. 

---

@Soup

If Power BI Embedded refers to the legency Power BI Embedded workspace collections which is being deprecated, there's no gateway. So to have your data updated, Azure SQL database/ Azure SQL data warehouse are the only options.

In the new Power BI Embedded capacity-based SKUs, you just publish your reports to Power BI Service. In this case, to have your data updated, on-premises SQL Server is available. You'll have to configure datasource in Power BI gateways for the local SQL Server.

As to pure on-premises solution, no azure, no gateway, you need Power BI Report Server.

[Soup]

Hi, 

So I'm simply trying to find out whether or not its possible to use a local SQL database to pull and refresh a dataset. The only options I've seen so far are:

- Azure hosted SQL Database. 

- The On-premises Data Gateway (which as far as I can see steams the local db to the cloud.)

Both options seem innappropriate for my situation. I really dont want to assign online DB resources or put further strain on the network. 

Thanks

[insoldev]

I'm not sure what other solution there could be. The power bi file is hosted in the cloud. If you data is local, then you need a secure tunnel to connect the two. The Power BI gateway does just that.