topic Re: PowerBI Embedded: Using Local SQL Database instead of Azure Sql... possible? in Developer

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

Soup — Wed, 22 Nov 2017 22:29:31 GMT

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

Power BI Embedded: Using Local SQL DB...

Soup — Wed, 22 Nov 2017 22:33:22 GMT

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

Re: Power BI Embedded: Using Local SQL DB...

insoldev — Thu, 23 Nov 2017 21:34:39 GMT

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.

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

Eric_Zhang — Fri, 24 Nov 2017 06:11:20 GMT

@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.