Forum Discussion

mwmckee's avatar
mwmckee
Frequent Visitor
8 years ago
Solved

Looking for help connecting to MRI SaaS data source

Hello!   Has anyone any experience or suggestions in using MRI software-as-a-service (SaaS) as a Power BI data source? MRI is an property management ERP system with SQL Server as its database....
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    mwmckee,

    There are two options for you to connect to MRI in Power BI Desktop.

    1. Directly connect to the underlying SQL Server database using SQL connector in Power BI Desktop.
    2. Contact MRI support about how to use its API to receive data, then use Web connector in Power BI Desktop to connect to the API. There is also a discussion for your reference.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

mwmckee,

There are two options for you to connect to MRI in Power BI Desktop.

1. Directly connect to the underlying SQL Server database using SQL connector in Power BI Desktop.
2. Contact MRI support about how to use its API to receive data, then use Web connector in Power BI Desktop to connect to the API. There is also a discussion for your reference.

Regards,
Lydia

mwmckee's avatar
mwmckee
Frequent Visitor
8 years ago

Hi Lydia,

 

Thank you for your response.

 

I was vaguely aware of the MRI API toolkit referred to in the link in option #2.  That is being investigated, although I understand MRI's fees for it are considerable.

 

Regards,

Michael

  • JakeTWalker's avatar
    JakeTWalker
    New Member
    5 years ago

    Hi Michael,

     

    Years later I am looking to complete a similar process to integrate MRI with Power BI and came across this thread. I am wondering if you ever came across a solution and how it turned out for you. Any insight you could share would be greatly appreciated!

    • mwmckee's avatar
      mwmckee
      Frequent Visitor
      5 years ago

      Hi Jake,

      It's great to see old posts have relevance even today.

      That said, unfortunately, I did not find a solution at the time, and the client changed focus. The Power BI integration project never got restarted.

       

      I hope you find a solution.

       

      Michael

    • AMStM's avatar
      AMStM
      New Member
      4 years ago

      Jake,

       

      I saw this thread and I am reaching out because we are trying to do this same here one year later.   Have you determined a solution and if so would appreciate any updates!