Skip to main content

Power BI

Needs Votes

Support for SharePoint list with Calculated columns

Vote (15) Share
Ann's profile image

Ann on 09 Mar 2017 04:49:45

When i try to connect to Sharepoint 2013 list that contains multiple calculated columns, i get an error- "Unable to Connect- Remote server returned an error (500): Internal server error".
It would be nice if Power BI could handle calculated columns in the list.

Comments (2)
Ann's profile image Profile Picture

JC on 05 Jul 2020 23:22:37

RE: Support for SharePoint list with Calculated columns

I need this as well. We have several Sharepoint lists that have calculated columns. I cannot import the lists until this is added. It has been over a year since my co-workers asked for this. I hate to keep telling them this is not available and we cannot use PowerBI for their needs Especially when they wanted to use Qlik in the first place.

Ann's profile image Profile Picture

Power BI User on 05 Jul 2020 23:18:02

RE: Support for SharePoint list with Calculated columns

I don't need the calculated columns. If they could just be excluded from the Power BI columns and work that would be great.