Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Unable to delete Sharepoint ID column

Hi all,   I'm experiencing a new issue where I cannot delete the ID column from a connected Sharepoint List and therefore it is affecting the other connected queries.   The column is imported int...
Need Help
  • christinepayton's avatar
    christinepayton
    3 years ago

    That's interesting, I didn't believe you until I went in and tried it myself - that is in fact what happens. 🙂

     

    The 1.0 connector does not have this same issue, so you could reconnect using 1.0 as a workaround. I end up using it 90% of the time anyway since 2.0 has issues with the 5k item threshold. 

AmyJPBI's avatar
AmyJPBI
Frequent Visitor
3 years ago

thanks for posting this, I have this same issue and it only appears with version 2.0 connectors too. It seemed to be something new that appeared because I had that error in the service but not the desktop version, then desktop replicated the error a week later and I could not understand why it only just appeared when previously the report had been fine not using the ID column.

Now in a new report I am connecting to something using 2.0 again and it makes me keep the ID column. Would be interested if you find out any more 🙂