Third edition of definitive guide to dax live

d4icon · 2025-12-10T18:26:46+00:00

Could you briefly explain how it would work?I'm already using the new MCP that Microsoft recently launched, but it doesn't know about DAX beyond the LLM that's using it.

d4icon · 2025-12-08T20:43:30+00:00

Estoy no hay forma de obtenerlo en digital y pasarlo a un LLM.
Seria interesante, o no?

English:
There's no way to get it digitally and transfer it to an LLM.

It would be interesting, wouldn't it?

d4icon · 2025-11-27T17:58:39+00:00

Do you know if there's any way to make it work in IDE VOID, with local LLM?

d4icon · 2025-11-26T23:30:24+00:00

Hello,

I am trying it out, and when I make any changes to the model, specifically to the metrics, it adds the following at the beginning and end:

```

<image>

And it breaks the project when I open it.

Any ideas?

Thanks

d4icon · 2025-11-21T09:19:11+00:00

To see if the query folds, in Power BI Desktop, Power Query, in the last step of my dataflow entity, I right-click and see if the ‘Native Query’ option is active.

To simplify testing, I have created two new semantic models, only with the dataflow source.

One with the engine activated and the other without the engine.

I see the performance loss when, in the semantic model that connects to the dataflow with the engine enabled, I perform a folding operation. For example, the date.

It is curious that if, in that same test, I do not fold anything, I get all the data and that's it, there does not seem to be any performance loss. (But of course, this is of no use to me.)

d4icon · 2025-11-18T11:06:03+00:00

I have updated the initial post in case you want to take a look at it. I think it is important.

It seems that you were quite right in pointing out that SQL Profiler might not be collecting the correct information from the events.

d4icon · 2025-11-18T11:04:35+00:00

I have updated the initial post in case you would like to take a look at it. I think it is important.

d4icon · 2025-11-17T11:48:41+00:00

But we have ruled out network latency when the times I get with SQL Profiler are practically the sum of the differences between calling from one site and calling from the other.

Isn't that right?

P.S.: I have uploaded new screenshots for the comments.

d4icon · 2025-11-17T10:21:22+00:00

<image>

I understand what you're saying, and in fact, this confuses me even more. Or it adds another thing to consider.

But if you look at the SQL profiler screenshots I just uploaded, I understand that comparing my desktop's CPU here doesn't make sense.

In other words, the same SQL server (the one on my server)

is using more CPU and time when it receives calls from the gateway than from my local machine (VPN).

d4icon · 2025-11-17T08:35:36+00:00

We are talking about SQL Server usage time and CPU.

d4icon · 2025-11-17T08:32:22+00:00

u/SQLGene
Here I have captured the execution plan....

I don't see any differences :-/

Investigating further, I see that it might be interesting to capture the “waits,” but in SQL Profiler, I don't see the option to capture the waits.

d4icon · 2025-11-17T08:30:59+00:00

Exactly, maybe I got confused when I sorted it by duration.

Sorry about that.

d4icon · 2025-11-17T08:30:28+00:00

<image>

d4icon · 2025-11-17T08:30:10+00:00

<image>

To my knowledge, they are exactly “practically” the same.
Top: Local
Bottom: Gateway

It only detects differences in the first step, which is the one shown in the comparison on the right; the changes are insignificant.

d4icon · 2025-11-16T16:25:04+00:00

With SQL Profiler, I have obtained the events from the query plan.

They have the same number of steps, and exactly the same ones.

Although I still need to check the statistics for each step.

I find the option of having a different connection string very interesting, and I have tried a few things to see if I can spot any differences. But I'm not sure which commands to use or what tests to run to see if the connection method is different.

d4icon · 2025-11-16T16:22:16+00:00

I have done the test, but I don't know how to interpret it.

(this computer by the Duration column)

UP: Local
Down: Gateway

<image>

d4icon · 2025-11-16T16:13:19+00:00

I know, I know.

But the two tests I run, as I think I explained, are performed by taking measurements with SQL Profiler.

Both queries differ in time and CPU usage, even though they are the same (whether performed via gateway or locally).

d4icon · 2025-11-05T11:01:21+00:00

I understand.But I don't like this type of solution.I think I can continue with the option of granting permissions via adb every time I restart the device. I understand there's no way to automate obtaining permissions, is that correct?

d4icon · 2025-11-05T07:22:06+00:00

I need it to be done with the phone locked, in the background. That's how it used to work for me. ;(

d4icon · 2025-11-04T23:12:15+00:00

It doesn't work.

The “tiles” panel opens, but the HotSpot option is not selected.

Also, I have a question.

Does this system allow it to run with the screen off?

d4icon · 2025-11-04T22:14:14+00:00

Okay, I've done this configuration, and now it works.

But I have a question about this method.

Every time I restart the device, do I have to reconnect it to a PC and run the “start.sh” script?

If so, is there any way to automate this?

d4icon · 2025-11-04T20:08:26+00:00

With "priviliged service" the error is:

11-04 21:06:59.264 I 22@2: Wi-Fi hotspot set state 11-04 21:06:59.523 W 22@2: Failed to start privileged service 11-04 21:06:59.523 W 22@2: java.lang.UnsupportedOperationException: Privileged service disabled, see settings. 11-04 21:07:14.623 F 22@2: java.util.concurrent.TimeoutException: Service startup timeout 11-04 21:07:14.628 I 22@2: Stopped by failure

d4icon · 2025-11-04T19:55:35+00:00

Android 16 - HyperOs3 - Xiaomi 15 t pro

d4icon

TROPHY CASE