PropertyMe-Power BI setup documentation

PropertyMe-Power BI setup documentation

Setup Instructions

1.Login or register with your company email address at https://integrations.syncezy.com



2. In the Home screen, find the PropertyMe Power BI integration and click “Sign Up”. If you already purchased the integration, navigate to My Apps

3. Once you go into My Apps and app details, you will have to connect your PropertyMe Account. Click on Connect and you will be redirected to the PropertyMe login page. Select the Portfolio you want to sync and press “Yes, Allow”. Your account should now be connected.



4. Once authenticated and connected, go back to the My Integrations  > PropertyMe Power BI page. Navigate to Database Settings.


5.Open PowerBI Desktop and select “Get Data”.

6. Search for MySQL database in the options that pop up. If you cannot see this option you will need to install MySQL-connector-net for Power BI.


7. In Server, copy the “Database Host Name” from the SyncEzy portal. In Database, copy the “Database Name” from the portal. Press ok.



8. In the next screen, go to the “Database” section and enter the Database Username and Database password given on the SyncEzy portal.



9. You will now get a list of tables. Select the tables you want and select “Load”. This will load the database table to your PowerBI project.



    Need more information?

    We help our clients 24/7 with their integrations and apps.

    What integrations do you offer? →


      • Related Articles

      • QuickBooks Time Power BI setup documentation

        Recommended Drivers You will need the latest MySQL Connector/NET driver in order to connect your QuickBooks Time data to PowerBI. The links can be found below. Download the driver based on whether your system is a 32-bit or 64-bit system. MySQL ...
      • PropertyMe to Power BI integration FAQs

        How often does the sync run? The sync runs every night and extracts data from PropertyMe Backup and makes it available to connect from an external dashboard/reporting tool. Can it be synced instantly? No, At this stage, we’re limited by the frequency ...
      • Quickbooks Time to Power BI integration FAQs

        This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com About the QuickBooks Time to Power BI integration How often does the sync ...
      • SimPRO Power BI Integration FAQs

        This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com. You can also dial any of the following numbers. Australia: +61 2 9136 ...
      • simPRO - PowerBI Setup Documentation

        Introduction Below is a guide on how to connect your SimPRO account to PowerBI or any other BI tool through SyncEzy’s server. Note: SyncEzy has a template PBIX file available. You will need a subscription to the SimPRO-PowerBI Service on ...