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

[AntoineTRICHET]

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

[lbendlin]

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

[AntoineTRICHET]

Hi

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

[lbendlin]

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.