cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sseverson12 Frequent Visitor
Frequent Visitor

ID Issue Appending Multiple Sharepoint Queries

Hello,

 

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!

2 REPLIES 2
Super User
Super User

Re: ID Issue Appending Multiple Sharepoint Queries

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?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-haibl-msft Super Contributor
Super Contributor

Re: ID Issue Appending Multiple Sharepoint Queries

@sseverson12

 

The fix should be included in the November release of PBI Desktop. Please check it later.

 

Best Regards,

Herbert