Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

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

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


Solution Sage
Solution Sage

Connect to a version of your source that has more of a flat table. If you're connecting to SmartSheets there should be a way to make an non-grouped/pivoted view and connect to that.


Power BI likes "flattened" datasources.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Kudoed Authors