The second report to run is the "Location Count" Report. This report will display statistical information about your projects in OpenGround and is a good example of a cross project PowerBI report.
To run the Locations Plotting example follow the steps below:
- Double click on the Location Counts.pbit file to open the template in Power BI.
- Enter your Cloud Parameters in the form below (see can be found using the Cloud Parameters report above)
- OpenGround Connector may request you to log in to your OpenGround account again. Click on "Sign in as a different user" on the Bentley OpenGround login form (shown below).
Note: the login is requested a second time as this is logging into your cloud instance and the first report logged into the OpenGround Controller API. Once you have logged into your instance, you should not need to log in again. - Login using your Bentley account and Allow the Request for Approval (shown below)
- Click the Connect button on the Bentley OpenGround login form to complete the connection. Once connected the data in the report will update and be displayed as shown below.
Note: You can save it as a standard Power BI report (extension *.PBIX) once you have entered the cloud information and run the report. Your cloud details are saved with the report so subsequent users will only need to open the report and click the refresh data to view the latest information.