PowerBI - How to retain data structure inside of a single column

Lknapton

Hi All

Smartsheets has an app inside of PowerBi for automatically importing data where you can simply right click and refresh on the Data panel, as required. This is Brilliant. I am having issues with the following problem:

When you 'get data' from PowerBi, you lose your data structure indicated with either a "+" or a "-" symbol which is inside of a single column. Does anybody know how to retain the single column data structure, so that for example in this instance, you can filter by project type 'BTK' inside of a single column? Currently it's raw data for a single column.

I hope that make sense.

Many thanks

Lynton

Genevieve P.

Hi @Lknapton

I don't believe it's possible to transfer hierarchy (+ - ) from Smartsheet to Power Bi at this time. Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!

Cheers,

Genevieve