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

edited 08/10/23 in Add Ons and Integrations

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