sharepoint - 不正确的数据从SharePoint列表中拉到Power BI(Incorrect data being pulled from a SharePoint list to Power BI)

Question

When I pull data from a SharePoint list into Power BI, the values are pulled incorrectly for columns having the data type -

(当我将数据从SharePoint列表中提取到Power BI中时，对于具有数据类型的列，值被错误地提取了-)

1. Person or Group - instead of names, numerical values are pulled.

   (人员或组 -拉取数值而不是名称。)

   I guess these are the IDs of the values

   (我想这些是值的ID)

2. Lookup - instead of the actual values, '[list]' is pulled in a nested column.

   (查找 -在嵌套列中提取“ [列表]”，而不是实际值。)

   When I expand, numerical values are shown.

   (当我展开时，将显示数值。)

   Again, seems like IDs

   (再次，好像ID)

All other data types are pulled properly.

(所有其他数据类型均已正确提取。)

To work around this problem, I first pull the data from the list to Excel and then to PBI.

(要变通解决此问题，我首先将数据从列表中拉到Excel，然后拉到PBI。)

However, I want to eliminate this manual step as the list will have frequent updates and I will need to pull the list data into Power BI regularly.

(但是，我想消除此手动步骤，因为列表将经常更新，因此我需要定期将列表数据提取到Power BI中。)

What should be done to pull the actual values as they appear in the list?

(如何提取列表中出现的实际值？)

  ask by Enigma translate from so

Answer 1

For the lookup columns: You need to pull in the lists where the lookup values are being looked up from and then create a relationship based on ID.

(对于查找列：您需要从中查找查找值的列表，然后根据ID创建关系。)

For the People: Look here: fully explained how to deal with Person object

(对于人民：看这里： 充分说明了如何处理Person对象)