I'm running into issues bringing in data from multiple Sharepoint lists into an appended table. It seems to choke a bit on the ID columns (which I obviously have no control over in Sharepoint.) Renaming the ID columns seems to get it to at least bring in the data, but it causes performance issues and creates problems when I try to work with the data in Power BI.
I believe this is a similar issue to the one brought up here: http://community.powerbi.com/t5/Desktop/item-ID-already-exists-in-the-collection/m-p/10070/highlight.... That issue was marked as solved, and it links to a TechNet post (https://social.technet.microsoft.com/Forums/en-US/66aa4bb6-f9ce-46a4-8b65-d28edd2ab565/issues-access...) that was also marked solved, but if you read the TechNet post it is clear that the issue was never resolved at all.
Is this issue being addressed? Or is there a different solution that I've missed somewhere?
Thanks in advance for any help!
I take it that you need the ID column for some reason? Can you just not import it and add an ID column in the query? What if you create a calculated column in SharePoint that has a formula of, essentially =[ID] and import that column instead of ID?
Proud to be a Datanaut!