Using Microsoft Power BI to access the data provided by the OData service is quick and easy. Microsoft Power BI is a great tool for creating reports and statistics.
For more details on how to work with Microsoft Power BI please refer to: : new window
To add the OData service to Microsoft Power BI, proceed as follows:
When you create an OData service, it is very likely that some of the required properties have lists as data types.
Lists are displayed as “List”. In the “Transform Data” dialog you can see these lists.
In order to make them useable, click on the “Expand” tool at the end of the column (see red box on the column in the screenshot) to choose an expanding option. Such an option is e.g. creating a new table; however, this requires additional work as relationships between the tables need to be set.
For lists, the approach to make them useable depends on the expected number of entries. If you can predict having only a couple of entries, expanding the list is an option. In this case, the other values are duplicated. If there are many entries, creating a new table based on the list may be a better solution.