Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm trying to store lists within records in a dataflow, but each time I save and close, it autogenerates steps "Transform columns" changing the type to text which produces and error then the step "Replace error" turning them null. I making a summary of events by date, so it looks something like:
Date | Count A | Count B | Count C | Set A | Set B | Set C
1/23/2020 | 123 | 456 | 789 | [List] | [List] | [List]
I know I can expand them on Date and maybe move them into individual tables, but I like how much cleaner this looks plus I want to know for future reference and to get better at this.
Thank you!
Solved! Go to Solution.
Figured out a workaround. I don't have that many Id's in each set moving daily, so I expanded the lists into a string. Then after the data is pulled in we can convert it back to a list if needed.
If you do know how to store values as lists within a dataflow, please let me know still for future reference. Seems like something that should be possible. Thanks.
Figured out a workaround. I don't have that many Id's in each set moving daily, so I expanded the lists into a string. Then after the data is pulled in we can convert it back to a list if needed.
If you do know how to store values as lists within a dataflow, please let me know still for future reference. Seems like something that should be possible. Thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.