Forum Discussion
Issue while getting data from Share point List to Power BI.
Power BI creating many unwanted columns while getting data from Share point list.
e.g. of unwanted field names,
FileSystemObjectType, Id, ServerRedirectedEmbedUri, ServerRedirectedEmbedUri.... & many more.
Please suggest some workaround for this issue..
Thanks in Advance!
8 Replies
- nandukrishnavs
Community Champion
Anonymous - You can use the "Choose Column" button to select only required columns.
Thanks a lot nandukrishnavs for your response.
I already have tried the same but issue is, my source SP list has 50 columns and i am getting almost 140 in PBI and many of the columns name you can refer in screen shot. cause of which the identification of fields also tough.
- nandukrishnavs
Anonymous - Try OData source instead of SharePoint list.
URL will be - https://<sharepoint site address>/_vti_bin/listdata.svc
amitchandak Thanks a lot for sharing the blogs, I am looking at them and shall keep you posted at the earliest.
Regards.
amitchandak unfortunately we do not have permission to download the power bi cleanup or dax studio tools.
