topic Re: PowerBI Embedded problem with Enterprise Gateway in Developer

PowerBI Embedded problem with Enterprise Gateway

baghbidi — Fri, 20 May 2016 18:39:30 GMT

Hi.

I have a report that gets data from local SQL Server instance. I have set up Enterprise Gateway and everything work fine on PowerBI desktop and website.

I have imported the report into a workspace and embedded it into my WebApp, but it doesn't show the data.

Other embedded reports which get data from Azure Database work fine!

Error is:

Couldn't load the data for this visual
You do not have access to an enterprise gateway.
Please try again later or contact support and provide the following details to help resolve your issue faster.

Error Code : DMTS_NoGatewayWithAllDatasourcesToBindError
Server : #####
Correlation : #####
Database : #####
ConnectionType{FieldValue}
Activity ID : #####
Request ID : #####
TimeFri May 20 2016 11:34:20 GMT-0700 (Pacific Daylight Time)
Version11.0.519.63518
Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net/

Is there any congiurations that I missed?

Thanks

Re: PowerBI Embedded problem with Enterprise Gateway

dimazaid — Fri, 20 May 2016 20:45:43 GMT

hi @baghbidi,
Appologies for the confusion. The PBI Embedded doesn't support on-prem connectivity yet. It'll be coming in the next few months.
I can see how the current message is confusing. It's a bug on our side and we'll fix soon.
Thanks for reporting!
Dimah

Re: PowerBI Embedded problem with Enterprise Gateway

pmdci — Mon, 22 Aug 2016 18:07:40 GMT

So...

It was said this would be "coming in the next few months". This was 3 months ago.

Since then Microsoft released Power BI Embedded to general availability without this fundamental functionality.

Just wondering... How many more months?

Regards,

Re: PowerBI Embedded problem with Enterprise Gateway

healypaul — Tue, 23 Aug 2016 05:38:15 GMT

Hi, we would also desperately like to know the timeline for allowing embedded Power BI to work with the enterprise gateway.

It's a critical missing piece for us, until it becomes available we are unable to deploy Power BI as our customer-facing reporting solution. Desktop/web versions won't work for us, our solution needs to be embeded in an existing application. Plus, our data warehouse environment is too large to reside in the cloud at the moment.

Dimah, has there been any movement on resolving this? Would really appreciate any insight you can give.

Many thanks

Paul

Re: PowerBI Embedded problem with Enterprise Gateway

mathayde — Fri, 23 Sep 2016 13:26:20 GMT

Hi Dimas, do you have news about it?

Re: PowerBI Embedded problem with Enterprise Gateway

pmdci — Fri, 30 Sep 2016 18:41:45 GMT

I heard through the grapevines that this was supposed to be announced "any time now" (sorry for the vagueness).

Anyway, I hope that Microsoft understand the situation they put their customers and partners in with such lack of information / roadmap.

We cannot make business decisions, let alone sell solutions to customers, if we don't have some sort of roadmap. The way I see it, Power BI Embedded is "forbidden" territory until this problem is resolved. This also impact other areas of Power BI. Just take a look at uservoice.powerbi.com and look at all feedback that is marked as "planned" that we have no idea when will be ready (sometimes even "started" is an issue).

Although we the community love Power BI and are always enthusiastic to see what's new, customers are (most likely) not as passionate as we are. They want roadmaps, timeline, and fully implemented functionality.

Re: PowerBI Embedded problem with Enterprise Gateway

Sunkari — Thu, 27 Oct 2016 07:52:16 GMT

@dimazaid: Any update on this.

Re: PowerBI Embedded problem with Enterprise Gateway

dimazaid — Thu, 27 Oct 2016 19:22:37 GMT

hi @Sunkari,

The date for this has moved to the end of the year.

Re: PowerBI Embedded problem with Enterprise Gateway

jskibo — Thu, 22 Dec 2016 17:21:13 GMT

@dimazaid: Any update on this? It is the end of the year now.

Re: PowerBI Embedded problem with Enterprise Gateway

topazo — Thu, 02 Feb 2017 15:57:47 GMT

Would like to hear status update as well.

Re: PowerBI Embedded problem with Enterprise Gateway

rsfurlan90 — Fri, 03 Mar 2017 23:42:32 GMT

I'm looking forward to see updates on this.

Re: PowerBI Embedded problem with Enterprise Gateway

dimazaid — Tue, 07 Mar 2017 16:10:09 GMT

Hello everyone,

Thank you for your patience, and sorry for not responding earlier.
We still do not have an on-prem solution for Power BI Embedded, it's still a priortiy for our teams to deliver this and we're working on it. We do not have an ETA at the moment, but will reply here once we do.

Thanks!
Dimah

The gateways team

Re: PowerBI Embedded problem with Enterprise Gateway

topazo — Sat, 06 May 2017 11:48:44 GMT

I guess waiting is over with new Power BI Premium.

If I understood correctly it costs minimum 5000 usd/month, so now I'm even further away from the idea I wanted to try 🙂

Re: PowerBI Embedded problem with Enterprise Gateway

shivprasads — Wed, 31 May 2017 10:03:07 GMT

we got a on prem gateway support for power bi embedded yet or still waiting for it ?
A quick update would b great !
Thanks in advance.

Re: PowerBI Embedded problem with Enterprise Gateway

dimazaid — Wed, 31 May 2017 22:08:38 GMT

Hi @shivprasads,

It should be coming in the next few weeks through Power BI Premium.

Re: PowerBI Embedded problem with Enterprise Gateway

jskibo — Thu, 22 Jun 2017 15:12:19 GMT

Hi @dimazaid,

I do not believe you answered the original question. Yes, Power BI Report Server will support on-prem connectivity to a SQL Server Analysis Services database, but what about PBI Embedded? When will PBI Embedded support on-prem connectivity?

Re: PowerBI Embedded problem with Enterprise Gateway

dimazaid — Fri, 23 Jun 2017 17:45:03 GMT

Hi @jskibo,

Sorry, I must have missed it.

Power BI Embedded now supports on-prem connections with the new Power BI premium announcements. Check it out here: https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-embedding/

You can use your Power BI gateway and connections in Embedded.

Thanks!
Dimah