Forum Discussion
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....
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
Quantra Technology Solutions ([email protected])
We have implemented PowerBI for many MRI SAAS clients. 1. API is good however needs a staging database for transformation requirements and data pull restrictions. 2. Report Scheduler - using Email and Powerautomate.