Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I'm trying to filter a query from a web url to remove a row that contains the type Record as shown on the attached image. It doesn't appear in the drop down list at the top and I can't work out how to do it programmatically. Any help appreciated.
Solved! Go to Solution.
Hi,
this will do:
= Table.SelectRows(PreviousStepName, each Value.Is([Data.], type record))
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
Hi,
this will do:
= Table.SelectRows(PreviousStepName, each Value.Is([Data.], type record))
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