Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

PowerBI Service and Remedyforce Integration Specifics

We are evaluating Power BI integration with Remedyforce. 

In this forum, I am looking at PowerBI Service (AWS/Azure) integration with Remedyforce. 

Can you please provide the official documentations of the integration architecture, methods, and processes?  

 

Thank you!

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Microsoft Power BI service (SaaS) can be connected directly to internet-accessible data sources, or to private data sources in an Amazon VPC. Connection to private data sources requires an application component called Microsoft on-premises data gateway. The Microsoft on-premises data gateway is downloaded and installed on an Amazon EC2 instance in the VPC and configured with Microsoft Power BI credentials. The gateway establishes an outbound connection to the Microsoft Azure Service Bus over the internet, and is configured in Microsoft Power BI to connect to data sources that it can access. Larger deployments can use multiple on-premises data gateways to balance load or increase fault tolerance.

     

    Reference:

    Set up Power BI integration - Power Apps | Microsoft Learn

    Connecting the Microsoft Power BI service to AWS data sources - Using Microsoft Power BI with the AWS Cloud (amazon.com)

    Microsoft Power BI and Azure Purview better together – now Generally Available | Microsoft Power BI Blog | Microsoft Power BI

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you, Anonymous . 

      My understanding is that Power BI Service can connect to Remedyforce with the native Power BI Salesforce connector.  Below Power BI connector should be applicable in either Report Server(on-prem AWS) or Service ( AWS or Auzre).  Correct me if I'm wrong. 

      Data source

      Connect from Desktop

      Connect and refresh from service

      DirectQuery / Live connection

      Gateway (supported)

      Gateway (required)

      Power BI Dataflows

      Salesforce Objects

      Yes

      Yes

      No

      No

      No

      Yes

      Salesforce Reports

      Yes

      Yes

      No

      No

      No

      Yes

          You explanation and reference are pertinent to integration between BI Service and AWS/Aurze data not the Remedyforce data. Correct me if I'm wrong.

       

      Thanks!