Solved: Error Message Trying to Load From SharePoint List

jerryh06238 · ‎07-10-2017

I'm trying to get data from a SharePoint list; however, I keep getting the below message. I have a couple of dozen other lists on the same site, of which I have not had any issues with. Thoughts?

Anonymous · ‎07-10-2017

@jerryh06238,

Does your SharePoint list contain calculated fields? If it contains, please remove calculated columns from the SharePoint list and check if the error goes away.

If your SharePoint list doesn't contain calculated columns, please use fiddler to capture the Http traffic between Power BI and SharePoint List.

Regards,

View solution in original post

Anonymous · ‎07-10-2017

@jerryh06238,

Does your SharePoint list contain calculated fields? If it contains, please remove calculated columns from the SharePoint list and check if the error goes away.

If your SharePoint list doesn't contain calculated columns, please use fiddler to capture the Http traffic between Power BI and SharePoint List.

Regards,

jerryh06238 · ‎07-11-2017

The list does have calculated fields. I took them out and the error went away. I have another list with calculated fields and it seems to work for that list.

jerryh06238 · ‎07-10-2017

I'm trying to get data from a SharePoint list; however, I keep getting the below message. I have a couple of dozen other lists on the same site, of which I have not had any issues with. Thoughts?

7-10-2017 11-31-43 AM.png