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

Anonymous  - You can use the "Choose Column" button to select only required columns.

 

  • 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.