How to get data from the Reference type
In order to export Reference type fields, first of all, ensure that data exist and is configured properly. Please follow step by step to check it.
1. Check that expected data exist. In some cases, if only empty rows are shown, it means that there are no data filled.
2. Check the order of exported rows. Sometimes empty rows are shown at the top of the list and not empty rows are hidden at the bottom. Check Column order to find out if any hidden rows exist.
3. Check export data when Use display value switcher is turned off/on. Some data can change its value depending on the switcher state.
4. The next case is when exported data is “sys_id”s in any Use display value switcher state. In this case, table configuration needs to be checked. For this, open the value of referenced table and check which one of the table fields has Display = true. Based on ServiceNow rest API exporter, data with only Display= true value will be exported. In this case, if only sys_ids are shown, it means all table fields are set as Display=false. Please follow the screenshots below to find out how to configure the table:
NOTE: In order to export not only parent-field but also its child-fields in-depth, use the dot-walking mechanism, that was implemented from Power BI Connector version 1.3.0. Navigate to Use a dot-walking mechanism to export Reference type data for more details.