Forum Discussion

nagaraj007's avatar
nagaraj007
Icon for Post Patron rankPost Patron
6 years ago

Unable to import all Sharepoint Column Name

Hello All,

 

I am very new to Sharepoint and i have few columns created by and modified by. But when i import sharepoint data to Power BI, these 2 are not getting imported. Please let me where i am making the error. Attached is the screen snip for your reference.

Need Help
Show and Tell

4 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi nagaraj007 ,

     

    Based on my test using Power bi desktop Version: 2.76.5678.782 64-bit (December 2019), I cannot reproduce your issue.

     

    Btw, I tested it by using the share point folder conenctor. Which one did you use in your scenario?

    M code for your reference.

    let
    Source = SharePoint.Files("https://xxxx.sharepoint.com", [ApiVersion = 15])
in
    Source

     

     

    • nagaraj007's avatar
      nagaraj007
      Icon for Post Patron rankPost Patron
      6 years ago

      Hi,

       

      Sharepoint.Files is not showing all the details which is showing in Sharepoint. 

      I am using Sharepoint.Contents, i am able to get other details but only Created by and Modified By is not reflecting.

      Should i need to make any changes in Sharepoint to reflect in Power BI?

      • nagaraj007's avatar
        nagaraj007
        Icon for Post Patron rankPost Patron
        6 years ago

        Hi,

         

        Below are the list of columns which are not importing to power bi. Is there i need to make changes in Sharepoint?