The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I am trying to set up an ingestion from an event hub to a KQL database. The difficulty in doing this is that there is a payload field that is a few levels down. I am trying to do this via the UI using an Event Processor to do this and I can go most of the way there. I can get to the point where I have a column with the payload.
Here is a simple example of that column: [{"name":"itemA", "section":"34", "key":"1234"}]
I could use "expand" here, but this breaks out the payload into 3 rows. The problem with this is that the "key" only exists in one of the rows and I have no way to tie it back to the other entries. Is there another option using Event Processor? I am trying to avoid doing this in code.
Solved! Go to Solution.
Hey! This doesn't appear to be a question related to Dataflow Gen2. I'll try to reroute this to the appropriate forum.
I have re-posted this question in the Warehouse forum.
Oops, sorry about that. Please let me know if I need to re-create.
Hey! This doesn't appear to be a question related to Dataflow Gen2. I'll try to reroute this to the appropriate forum.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.