expanding person or group column

[jcastr02]

I have a person or group column in Sharepoint that I can't expand the record in Power BI.  The BI keeps spinning and spinning - and will not allow me to expand the record to extract the name.  Any other ways around it or ideas?  I have tried to clear cache - and reconnect credentials.

[christinepayton · Accepted solution]

Are you using the 1.0 connector when you pull it? There is a bug with the 1.0 connector where it fails to expand person columns seemingly at random - it's been this way for years. You can fix by either reducing the api version number in the advanced query editor by 1 or try connecting with the 2.0 connector. Both will give you different column names/data structure, so you may have to redo the rest of the query steps depending.

[Anonymous]

Hi @jcastr02 

Try the following steps to see if there is an improvement.

1. Use a different connection to get data from SharePoint. 

Power BI: Two Way To Get Data From SharePoint List / Library | Microsoft Learn

2. Optimize queries for quick access to SharePoint list data. 

Solved: SharePoint list query alternative or optimization - Page 4 - Microsoft Fabric Community

https://hoosierbi.com/2022/11/12/updated-get-sharepoint-list-data-fast/ 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lkalawski]

Hi @jcastr02 ,

Please try to limit rows to let's say 2 and then try to expand the column - It seems that PBI has a lot of data to load and performance drops.

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[jcastr02]

@lkalawski  I tried to filter the query to 1 record and still the issue was faced.