Forum Discussion
HELP with table
Hello, When I upload my sharepoint list to power bi it uploads correctly and in the right order when I look at the query editor BUT when I add the data to the table values or matrix everything is...
In the PowerQuery editor, add an index column to the imported table.
Then, you can either
- In the model set the sort by column of [column 1] to be the index column.
- Pull the index column into your table, sort it by that then set it to be so narrow you can't see it.
Might I also suggest, in the PowerQuery editor adding the following steps.
- Remove top 1 row
- Use top row as header
That way our table will have the same column headers as our sharepoint list.