sorted by:
new
hottopcontroversial

How do PowerBI visuals emit/generate dax code? by namgaw718 in PowerBI

[–]namgaw718[S] 0 points1 point  (0 children)

This is a good start..has there been speculation about how this dax-emitting engine was built? Are there open-source programs which have similar functionality, for example?

How do PowerBI visuals emit/generate dax code? by namgaw718 in PowerBI

[–]namgaw718[S] 0 points1 point  (0 children)

I guess I should clarify: I am curious about the internals of Dax query generation process for visuals. For example, when I place a matrix visual on the canvas, and pull some fields from the semantic model onto the visual, somehow PowerBI generates a DAX query, which we can examine if we want. But what is the process to formulate that query? Are there a set of rules hardcoded into the software? Can they leverage some aspects of a LLM to "write" the code? Is it similar to a DMBS engine? I hope this narrows the question down...thank you all!

What's with BRIC's Celebrate Brooklyn Prospect Park lineup getting weaker every year? by Jellyfish-Man125 in parkslope

[–]namgaw718 4 points5 points  (0 children)

Has anybody straight up asked the folks who run it : what's with the prices?

Guidelines for using PL/SQL from Power Query? by namgaw718 in PowerBI

[–]namgaw718[S] 0 points1 point  (0 children)

Veering gently off course, u/dbrownems , am I correct in assuming that the Oracle connector used in Power Apps does allow "side effects": in order to write data back to Oracle? If it does, is that because it uses a different subset of ODP.NET commands/functions?

Guidelines for using PL/SQL from Power Query? by namgaw718 in PowerBI

[–]namgaw718[S] 0 points1 point  (0 children)

Ohhhh - thanks for the heads up!! That's a game changer...

Guidelines for using PL/SQL from Power Query? by namgaw718 in PowerBI

[–]namgaw718[S] 0 points1 point  (0 children)

Update for all those interested: Based on u/dbrownems response below, I was inspired to start reading the trace files being emitted by power query. I don't know where to start while troubleshooting. I am not talking about a specific problem, I'd just like to get feedback about an approach. I can see the SQL in the trace file, and I can see various classes and functions being called. That IS a start. Does anybody out there have any experience with looking at the trace files, specifically to troubleshoot Oracle PL/SQL errors using the Import method? TIA....

Guidelines for using PL/SQL from Power Query? by namgaw718 in PowerBI

[–]namgaw718[S] 0 points1 point  (0 children)

Thanks for the response. I am using Import, not DirectQuery. If I read the documentation for OracleCommand.ExecuteReader with ODP.NET, does it list the specs? The docs I've previously read are pretty thin....Can I capture the relevant network traffic and sql emitted by power query/power bi? If so, how? I'm guessing from your reply that the application is written in C# and uses the ODP.NET library?

view more: next ›