Forum Discussion

baghbidi's avatar
baghbidi
Microsoft Employee
10 years ago

PowerBI Embedded problem with Enterprise Gateway

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

Need Help

16 Replies

  • healypaul's avatar
    healypaul
    Regular Visitor
    9 years ago

    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

    • pmdci's avatar
      pmdci
      Advocate V
      9 years ago

      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. 

    • topazo's avatar
      topazo
      Advocate I
      9 years ago

      Would like to hear status update as well.

  • dimazaid's avatar
    dimazaid
    Microsoft Employee
    10 years ago

    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

    • pmdci's avatar
      pmdci
      Advocate V
      9 years ago

      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? :smileywink:

       

      Regards,

      P.