Forum Discussion
Auto converted columns into table
Hi Expert, Is there any possible to convert the table into list as i can see connect the data from Sharepoint and it auto convert the column into table. I want Owner name in that column. In sharepoint the column type is PERSON.
Power Query
7 Replies
- PwerQueryKeesSuper User
Try clicking the little icon top right with the two arrows.
Then you can select the columns you want to see from the merged table...
- AnonymousNot applicable
Hi PwerQueryKees Thanks for suggest. I have tried the same. When it expand No columns found. Is there any possible to convert into LIST this coloumn. So then may be i can select column i felt.
- PwerQueryKeesSuper User
If you click in any cell, to the right of the word table, what does the bottom of your screen say? Can you post a screenshot?
- PwerQueryKeesSuper User
Converting to a list will probably fail as well, so let's find out why expand does not work first....
- AnonymousNot applicable
When click on the cell it saying as below screenshot.
- PwerQueryKeesSuper User
There's your answer. Next question is why you get an internal sever error, but that is beyond my area of expertise...