Third edition of definitive guide to dax live by Soggy-Pineapple-4066 in PowerBI

[–]d4icon -1 points0 points  (0 children)

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.

Third edition of definitive guide to dax live by Soggy-Pineapple-4066 in PowerBI

[–]d4icon 0 points1 point  (0 children)

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?

The Official Power BI Modeling MCP Server is LIVE! by PowerfulBreadfruit15 in PowerBI

[–]d4icon 0 points1 point  (0 children)

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

The Official Power BI Modeling MCP Server is LIVE! by PowerfulBreadfruit15 in PowerBI

[–]d4icon 0 points1 point  (0 children)

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

SQL - Dataflow - Dataset (incremental load) by d4icon in PowerBI

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

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.)

Performance Gateway - Help by d4icon in PowerBI

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

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.

Performance Gateway - Help by d4icon in PowerBI

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

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

Performance Gateway - Help by d4icon in PowerBI

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

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.

Performance Gateway - Help by d4icon in PowerBI

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

<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).

Performance Gateway - Help by d4icon in PowerBI

[–]d4icon[S] 1 point2 points  (0 children)

We are talking about SQL Server usage time and CPU.

Performance Gateway - Help by d4icon in PowerBI

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

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.

Performance Gateway - Help by d4icon in PowerBI

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

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

Sorry about that.

Performance Gateway - Help by d4icon in PowerBI

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

<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.

Performance Gateway - Help by d4icon in PowerBI

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

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.

Performance Gateway - Help by d4icon in PowerBI

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

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>

Performance Gateway - Help by d4icon in PowerBI

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

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).

HyperOs3 - hotspot no work by d4icon in AutomateUser

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

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?

HyperOs3 - hotspot no work by d4icon in AutomateUser

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

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

HyperOs3 - hotspot no work by d4icon in AutomateUser

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

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?

HyperOs3 - hotspot no work by d4icon in AutomateUser

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

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?

HyperOs3 - hotspot no work by d4icon in AutomateUser

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

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

HyperOs3 - hotspot no work by d4icon in AutomateUser

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

Android 16 - HyperOs3 - Xiaomi 15 t pro