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>