Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Power BI and CRM On Premise

  • 1.  Power BI and CRM On Premise

    TOP CONTRIBUTOR
    Posted 7 days ago
    We're starting to roll out a few instances of Power BI.  Is there anything to be concerned about from a performance standpoint regarding this tool hitting our production CRM database?  Microsoft allows it in the cloud so I'm thinking it may be okay.  I don't want to have to define a whole new data warehouse to enable this tool in the organization.  I'd appreciate any thoughts and experiences.

    ------------------------------
    Donna Liotta
    Manager Business Applications
    National Safety Council
    Itasca IL
    ------------------------------


  • 2.  RE: Power BI and CRM On Premise

    TOP CONTRIBUTOR
    Posted 5 days ago
    Hi Donna,
    We are on-prem as well. I have a pretty robust Power BI report built that is connected to MSD and refreshes each night.  I do get complaints from users when I do any refreshes of the entire report during business hours.  Otherwise, all is good.  We connect directly to the SQL server via a gateway.


    ------------------------------
    Tim Dailey
    Sr Marketing CRM Administrator
    Starkey Hearing Technologies
    The CRM Dude (freelance consultant)
    Eden Prairie MN
    ------------------------------



  • 3.  RE: Power BI and CRM On Premise

    Posted 4 days ago

    Hi Donna

     

    As Tim suggests, using the PowerBI Gateway to connect to the On-Premises SQL is the way to do it. It's fairly easy to set up, can't really break anything. Give it a go.

     

    The Gateway provides a conduit from PowerBI to On-Premises SQL. You still design your PBI using the PBI Desktop then publish them to the PBI cloud and connect to the D365/CRM DB via the gateway.

     

    Pete






If you've found this thread useful, dive deeper into User Group community content by role