topic PowerBI Embedded: Connection (Direct query) to SQL databases (onpremise) in Developer

PowerBI Embedded: Connection (Direct query) to SQL databases (onpremise)

tomazk — Thu, 14 Jul 2016 13:06:09 GMT

Hello

As it seems to me, at the moment (after PowerBI Embedded became generaly available) it still does not support direct queries to SQL database (setup on premise or on VMs on Azure).

Please anybody correct me if this is supported and direct me to right direction (where can I see how to setup such environment).

In other case, is there maybe already a timeline, when and if this will be supported?

Re: PowerBI Embedded: Connection (Direct query) to SQL databases (onpremise)

shay_cullen — Wed, 14 Sep 2016 12:49:19 GMT

Any response on this from MS?

Re: PowerBI Embedded: Connection (Direct query) to SQL databases (onpremise)

priyanthi — Thu, 04 May 2017 06:53:31 GMT

Hi, Please let me know if this feature has been incorporated. I'm basically using Sql on VM azure and then creating a direct query report. This report im trying to embed using Power Bi embed Service. I get a "data source has no credentials " error. Please help me on this.

Re: PowerBI Embedded: Connection (Direct query) to SQL databases (onpremise)

priyanthi — Thu, 04 May 2017 06:59:14 GMT

Hi, Is there any reply from MS on this. I'm basically using a Sql on VM Azure, then creating a Power Bi report using Direct Query connected to this Sql. I'm using power bi embed service to embed the report in my application. I have used the Provision Sample provided by the team and deployed the Report from PowerBi Desktop onto the WorkSpace. I'm now struggling with updating the connection string (point 7). When i run the web application i get error saying "No credentails for the data source".

Please let me know if the power bi embed is possible for direct query reports which uses Sql on VM Azure.