Forum Discussion
Advocate IBasic manipulation of data from events
Hello Anonymous .
I was checking and actually there is a nice way to have this automatic updates, with out going to external services or adding extra complexity.
In KQL, we just need to use an "Update Policy" and that is all ! 👏Have a look here below:
Omar C.
Advocate IHello Anonymous , thanks a lot for your great and valuable feedback.
I am quite new on the community and now it can see that it is a great thing ! 👏
Yes !!! The decoding from base64 is working very ok, thanks for the tip.
When I do the decoding, I will always get a JSON file that will always have two fields, value and at. With KQL is also posible to retrieved this two wich is great.
Using an extend I can add the new fields as new columns, that is fantastic !
The next step would be to save this somewhere (I imagine), a new table with the format that I want, to pass it then to the application Power BI where it would be finally displayed.
I could do that now, running the KQL query and it would be 'ok', however my question remains the same, how could I keep doing this transformation continuously? Or should I do this manual each time? I am only using Fabric so I have no access to Azure tools. I have been learning a lot about all this data engineering process and I am also curious to know if some other people have the same challenge and how they solve it...
Let's keep the case open a little bit more, maybe some other people interested here can also have a look.
In any case, I will report any progres ! 👏
Greetings from Belgium 🇧🇪
Omar C.