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.