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.
Hello PowerBI-ians,
I tried getting data through custom column and using Web API string in it. Issue I am facing is that there's a mixture of both Records and Lists and I am unable to expand or remove records or anything. Kindly help.
Solved! Go to Solution.
You have to convert either the list into a record or vice versa, see this post as a start: https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi...
You can also add 2 column: 1st to extract the list and 2nd to extract the record (and leave the others null) then both are expanable.
Really depends how you need the data.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Any chance you can share the API that you are using? @ImkeF might have some Power Query magic that could address this. I am thinking perhaps a function that determines if it is a Record or a List and performs the appropriate actions, but you don't have a lot of information to go on.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
You have to convert either the list into a record or vice versa, see this post as a start: https://www.thebiccountant.com/2017/07/25/how-to-expand-a-column-that-cannot-be-expanded-in-power-bi...
You can also add 2 column: 1st to extract the list and 2nd to extract the record (and leave the others null) then both are expanable.
Really depends how you need the data.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |