Table visual not showing duplicate

[irwinkriss]

Hello, I want to display as Table visual exactly the same as query editor.

However, the Table Visual showed as below. with only a single row of "NA" data.

Please assist thanks!

[Anonymous]

Hi,

Just do one thing: add an index column from the power query editor and use that index column in your visual as well. You will get all the rows in the visual.

Accept the solution if it is working for you.