Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.... &...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous  - Try OData source instead of SharePoint list.

 

URL will be - https://<sharepoint site address>/_vti_bin/listdata.svc

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    nandukrishnavs  have already tried oData, Share point list & share point online list. same issue persists everywhere.