cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akg1421 Occasional Visitor
Occasional Visitor

Not able to expand/get Person Group column in Powerbi from SharePoint Online Task List

Trying to get value of Assigned To column of SP Online Task list in Powerbi. Go to Edit Query > Click on Expand to New Rows... but it fails with message "No columns were found"

5EkpL.png

 

 

 

Then there is another column ParentID with rows populated as Table and it is next to AssignedTo. When I expand it new columns are created and ParentID.AssignedTo is also created but it reads Error. Error message reads: "DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. (Specified method is not supported.)"

 

pHNr9.png

 WLGN7.png

 

 What is the issue? I require to show Assigned To display Name in a visual... (Tried with 1-calculated column which is not allowed, 2-WF to update Text column with Assigned To info but WF cannot be fired simultaneously for 200+ items)

 

JzZPJ.png

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: Not able to expand/get Person Group column in Powerbi from SharePoint Online Task List

Hi @akg1421 ,

 

Please try to delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works.

 

Or upgrade the Power BI Desktop to the latest version 2.75.5649.582 , and try it again.

 

You can refer to the similar cases:

 

Power Query (Power BI) and SharePoint Lists

 

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Se...

 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", to get further help.

 

Best Regards,

Amy

 

Community Support Team _ Amy

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

Re: Not able to expand/get Person Group column in Powerbi from SharePoint Online Task List

I believe AssignedTo is also found under FieldValuesAsText. Try expanding that as well. We do a lot of work with SharePoint sourced data. 

 

Hope this helps!

--Treb

 

Check out our Power BI blog posts at https://marqueeinsights.com/blog

Community Support Team
Community Support Team

Re: Not able to expand/get Person Group column in Powerbi from SharePoint Online Task List

Hi @akg1421  ,

 

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors