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
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
I think this is due to my data having rows that are blank and others as Tables
Can anyone help tweak this fuction to accomodate "". I dont want to lose the rows of data, just expand where possible etc.
This prior thread includes multiple approaches to solving this:
You can add this column as a new query and expand it then just merge again with previous table.
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?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
67 | |
61 | |
23 | |
17 | |
12 |