Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Power Query does not load all fields of my sharepoint list and it moves the content of columns

Hi Power BI experts

 

I know it is a bit strange.
When I load a shrepoint list with Power Query, one fields of the list is not loaded. Is there a limit on the number of column that one can retrieve from a shrepoint list in Power Query ?

Moreover I have the content of this column but in another column. And the content of this column has been moved tothe following column too.
Here a visual explanation of my issue which is disconcerting.


Thank in advance for your help and your good ideas

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

    which connector you are using, 1.0 or 2.0 (Beta)  ?  How many lookup fields are in your list? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi

      I am using 1.0 connector and there are 6 lookup columns I think.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        5 years ago

        That might be it. You are likely hitting the limits. I don't recall the actual number , it is documented in the connector details somewhere.