Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have taken over a Power BI report from someone who has now left (so I can't ask them questions), and I came across the attached query which I am trying to wrap my head around. I want to understand how it works and why "2023" isn't in the table.
I see that it is doing a binary encoding in base64 of that string (why that string?), and then decompressing it (why encode and then decompress?), then returning the results of that json document (why is it a json document?), and then creating a table by parsing that list. The "let _t = ..." I guess is defining the column or something, but I don't really understand any of the syntax in that bit. Overall, why does this work, and how do I get "2023" to appear?
Is it just a matter of that specific string encods and then decompresses into that specific list? And therefore a different string would give a different list?
How would I go about testing all the parts of this DAX individually?
Thank you.
Solved! Go to Solution.
@Loubot3000 That's an Enter Data query and is just kind of how it works. If you want to really understand what is going on, I made a video on it (below). Also, you should be able to edit the data by clicking on the gear icon for the Source step.
@Loubot3000 That's an Enter Data query and is just kind of how it works. If you want to really understand what is going on, I made a video on it (below). Also, you should be able to edit the data by clicking on the gear icon for the Source step.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |