topic Re: Power BI Embedded and Direct Query in Developer

Power BI Embedded and Direct Query

jhonatas — Wed, 09 Nov 2016 18:14:02 GMT

Recently i posted a new topic here asking how to update a report(dataset) through power bi api. For testing purposes everything works good,

Our problem now is, we cannot for every report open pbix > click update > save. and then upload a new pbix file .

This kind of update needs to be automatic.

I read across the forum that using Direct Query this type of refresh works fine(with Azure DB). My question is, this refresh works for data only on azure or using a gateway i can refresh a dataset where the data is on my servers?

If this works with gateway and on-premise data, how to make this work with Power BI API?

Re: Power BI Embedded and Direct Query

Sunkari — Thu, 10 Nov 2016 10:24:45 GMT

This doesn't not work with gateway

Re: Power BI Embedded and Direct Query

jhonatas — Thu, 10 Nov 2016 10:51:38 GMT

Hi Sunkari, thanks for your answer.

So, the only way to make my report refresh data (beside reuploading a pbix) is using an Azure DB & D.Query? ....

Re: Power BI Embedded and Direct Query

v-chuncz-msft — Mon, 14 Nov 2016 09:41:18 GMT

@jhonatas,

With Power BI Embedded, you can use DirectQuery with cloud data sources but not on-premises data sources at this time. See FAQ at https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-faq/#what-data-sources-are-currently-supported-with-power-bi-embedded.

Re: Power BI Embedded and Direct Query

rsfurlan90 — Mon, 06 Mar 2017 14:06:59 GMT

Hello,

I'm exposing SQL Server Database on the internet, so it can be accessed anywhere from its DNS + port (xxx.contoso.com, 1433).

Is there a way to use Power BI Embedded and Direct Query in this scenario? In this case, I believe that the On Premises Gateway is not needed. Can anyone assist me, please?

Re: Power BI Embedded and Direct Query

lh_son — Thu, 08 Jun 2017 22:54:18 GMT

Hi,

Does anyone have an answer to rsfurlan90's question? I'm also facing the same issue here.

Is there a way to use Power BI Embedded in Direct Query mode, and with datasource come directly from MS SQL Database installed on Azure Virtual Machine?

Some articles seem to show that Power BI Embedded in Direct Query mode, can only work with

+ Azure SQL Database

+ Azure SQL Database Warehouse

But some articles seem to suggest there is a way to work around it?

And just wondering is on premises Gateway only working with Power BI (not Power BI Embedded)?

Any hints will be appreciated.

Thanks.

Re: Power BI Embedded and Direct Query

lh_son — Thu, 08 Jun 2017 22:55:35 GMT

Hi,

Does anyone have an answer to rsfurlan90's question? I'm also facing the same issue here.

Is there a way to use Power BI Embedded in Direct Query mode, and with datasource come directly from MS SQL Database installed on Azure Virtual Machine?

Some articles seem to show that Power BI Embedded in Direct Query mode, can only work with:

+ Azure SQL Database

+ Azure SQL Database Warehouse

But some articles seem to suggest there is a way to work around it?

And just wondering whether on premises Gateway is only working with Power BI (not Power BI Embedded)?

Any hints will be appreciated.

Thanks.

Re: Power BI Embedded and Direct Query

rsfurlan90 — Tue, 17 Apr 2018 22:12:53 GMT

I am still waiting.

Re: Power BI Embedded and Direct Query

Anonymous — Mon, 07 Oct 2019 15:32:05 GMT

@rsfurlan90 I'm facing the same issue. Do you have any news ?

Re: Power BI Embedded and Direct Query

hampusrude — Tue, 03 Nov 2020 17:36:46 GMT

Is this still a limitation?