Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
obesli
Frequent Visitor

DataSource.Error: SharePoint: Request failed

 Hi,

 

I created a report in PowerBI desktop, which connects to a SP2010 and retrieves data from sharepoint lists.

Everything works fine, but yewsterday when I want to refresh data in one list, I got following error. I use different lists in the same directory and I got this error only one list. I tried to create new connection in a blank PBIX and the same error appears again.

 

Here is the error:

 

Error.PNG

1 ACCEPTED SOLUTION
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @obesli,

I have just deleted the calculated column from my share point site library  then the problem solved.

 

Solution link

http://sharepoint.stackexchange.com/questions/65902/listdata-svc-gives-a-500-error-when-querying-som...



Were there any updates on that list recently? Could there be any calculated columns added on that list? Here is a similar thread, could you go to check if it helps in your scenario? Smiley Happy

 

Regards

View solution in original post

1 REPLY 1
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @obesli,

I have just deleted the calculated column from my share point site library  then the problem solved.

 

Solution link

http://sharepoint.stackexchange.com/questions/65902/listdata-svc-gives-a-500-error-when-querying-som...



Were there any updates on that list recently? Could there be any calculated columns added on that list? Here is a similar thread, could you go to check if it helps in your scenario? Smiley Happy

 

Regards

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors