Using OData Services with Microsoft Power BI 

 

Use the following steps to load data from MVP One into Power BI using an OData feed.

1.Launch Power BI.

2. Select File> Get Data> OData Feed.

3. In the OData feed window that opens you will then enter the URL for the MVP Data you want to load. Use the format "https://customername.mvpplant.com/publicapi/v1/datatype."" 

For example: https://testing.mvpplant.com/publicapi/v1/MeterReadings. This will load the data from the Meter Readings section of the chosen MVP site.

 

4. After selecting OK another window will open displaying a preview of the data to be loaded into Power BI.

5. Select Load and the MVP data will be loaded into a Data Set in Power BI.

 

From here the data loaded in from MVP can be manipulated and used to build custom reports.