Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
adamplowman
New Member

Help with Expanding Tables

HI All 

I have followedthis blog post

 

https://blog.crossjoin.co.uk/2014/05/21/expanding-all-columns-in-a-table-in-power-query/

 

And i get the following error 

adamplowman_0-1660313195858.png

I think this is due to my data having rows that are blank and others as Tables 

adamplowman_1-1660313247946.png

 

Can anyone help tweak this fuction to accomodate "". I dont want to lose the rows of data, just expand where possible etc. 

4 REPLIES 4
AlexisOlson
Super User
Super User

Anonymous
Not applicable

You can add this column as a new query and expand it then just merge again with previous table.

Anonymous
Not applicable

You need to remove blanks and nulls to expand

but if i remove them i will remove the rows completely. Which i dont want todo. Is there a way to dynamically expand?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors