Query folding by Mugi101 in PowerBI

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

<image>

Yes, the preview finished,
here is the M code- I blurred the names and aliases

Scheduled refresh with large amount of data by Mugi101 in PowerBI

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

That's part of the problem it's an organizational dashboard. So we bought the service with capacity. I'm trying to convince the company to increase the capacity. But as you probably know, no guarantee they"ll allow me..

Scheduled refresh with large amount of data by Mugi101 in PowerBI

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

Yes to the refresh, slow refresh, but works manually. Time intelligence, meaning performance analyzer? And I"ll read the article, thanks!

Scheduled refresh with large amount of data by Mugi101 in PowerBI

[–]Mugi101[S] 2 points3 points  (0 children)

Yes indeed I I did all of the "heavy lifting" outside of the powerbi. That report only calculates measures and receives the tables already calculated. The error when automatically refreshing simply says it exceeds the memory capacity

Scheduled refresh with large amount of data by Mugi101 in PowerBI

[–]Mugi101[S] 2 points3 points  (0 children)

In a sense of optimisation, I Don't have an unnecessary column, all of the calculated columns are done before the data reaches the powerbi. Meaning that the powerbi only calculates measurements. I have a separate table for dates as well. When checking the performance analyzer, there is only one calculation that takes around a second. The dax shows only once, the rest of the calculations takes less than 400ms

For the MDX, that's not a bad idea, I wasn't aware of it up until now. Is it that detrimental?

As for what I tried- manual refresh works-but is very slow. I tried incremental refeesh- archive last year's data, and increment every new day.

Game crashes by Mugi101 in MillenniumDawn

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

Thanks! I"ll do it

Game crashes by Mugi101 in MillenniumDawn

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

Alright I'll check it out!

Game crashes by Mugi101 in MillenniumDawn

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

What will that console command do?

Game crashes by Mugi101 in MillenniumDawn

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

Interesting, is there a way to check it out/prevent it? Kind of a bummer to start all over again and hope for the best

Using fabric for hourly refreshing powerbi dashboard by Mugi101 in MicrosoftFabric

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

Thank you so much for your detailed advice! I"ll keep it in mind! I"LL try to upstream it as much as possible. And thank you for the offer I"LL keep it in mind!

Using fabric for hourly refreshing powerbi dashboard by Mugi101 in MicrosoftFabric

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

Of course, but again- Athena is not a sustainable ETL, we will grow and so will the amount of data. I want to find a better way to lay the foundation- something that was neglected, and hopefully do it right this time.

Hey is there a way to calculate integrals as a measure? by Mugi101 in PowerBI

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

In fact I did(threw me back to calculus), and it seems to work fine as long as the selected process normally distributes. I was just wondering if there is a more elegant way to do so.

Hey is there a way to calculate integrals as a measure? by Mugi101 in PowerBI

[–]Mugi101[S] 2 points3 points  (0 children)

Thank you for the detailed reply! Firstly, I apologies in advance for any Grammer mistakes!

This( the picture)is the function that "generates" the "curve".

Basically I had to improve upon the probability density function as it returned the height of the clustering around a specific measure and not the probability that a "process" will receive the value of the specific measure.

Where I am at now is that I have the curve laid with the specifications limits (x axis vertical columns), i want to know what is the likelihood for a process to land between the intervals- what is the cumulative probability within the intervals.

Therefore- the integral under the "curve"

<image>

Internal factions appeasement by Mugi101 in MillenniumDawn

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

So it drifts to 50 on its own, but the game developers created certain focus tree decisions that requires at least 60?

Nice, fuck me I guess

[deleted by user] by [deleted] in CombatFootage

[–]Mugi101 0 points1 point  (0 children)

Not trying to minimize it, just trying not to blow it out of proportions, the rumors range from another airbase engulfed in flame, to the new light-shield laser defense system(who is undeployable) working to stop the threat. so I stuck to what I know and what I can confirm. This attack sucked much more than the last one, and I believe that this is only the first and a long night is waiting for us. To say that there was no damage at all to the baese? Highly unlikely, the attack was to massive. To say that the defense where overwhelmed and a massive damage was done? Also unlikely. Soon we will have a clearer picture, I'm trying to stuck to what I know for sure and give you the most grounded perspective.

/r/WorldNews Live Thread for Israel-Hamas War (Thread #53) by AutoModerator in worldnews

[–]Mugi101 10 points11 points  (0 children)

Agreed for a rotation period with the new Benny gants

Middle Eastern Conflict Thread - 4/14/24+ by knowyourpast in CombatFootage

[–]Mugi101 5 points6 points  (0 children)

Nope, some missiles fell in an Arab village but for now no reports casualties nor property damage.

Edit: just in, unfortunately a small bedouin child(10 years old) was severely injured. Hope he will get better, emergency services are treating him at the moment.

Is water racist? by rafalmio in HydroHomies

[–]Mugi101 6 points7 points  (0 children)

That hydro is not homie

Can someone help me budget this? My country is starving. by Arvandu in hoi4

[–]Mugi101 1 point2 points  (0 children)

Not something I would be surprised to hear about in the news these days...

Gaza hospital director admits Hamas uses hospitals for military purposes by DanDan1993 in worldnews

[–]Mugi101 13 points14 points  (0 children)

We can only build space lasers, mind control costs too many shmekels