Importing using the Power Bi Connector

I'm starting to use Smartsheet and wanting to bring the data into Power Bi to present along with other data.

But I have an issue and can't believe no one else has come across it so assume I'm doing something wrong.

All looks good in SS, hierarchy is expandable etc.

But when I bring the data into pBi, the data is the same but no means on picking out the hierarchy - its just one big table

Is this normal? Correct?


would appreciate any input on this.


Thanks.

Answers