Skip to main content
Microsoft Idea
Liquid error: Exception has been thrown by the target of an invocation.

Vote (0) Share
's profile image

on

Comments (Liquid error: Exception has been thrown by the target of an invocation.)
's profile image Profile Picture

Lauren Dittmann on 03 May 2024 05:44:52

RE:

Agreed. Unless MS can figure the scalability thing out first for us :) Although current roadmap developments (query scale-out and auto-scale) do help with scaling up for higher concurrent user rates, scaling up for faster interactive query performance remains out of reach - leaving smaller teams unable to 'buy some time' to optimize reports while still being able to deliver reports in a timely and non-aggravating manner to end users. Although there is the inherent limitation from the Vertipaq engine presented by the FE engine (which can only use 1 stream and 1 core at a time and therefore cannot be sped up), it is disheartening that even a high-SE engine-based query is not 'scalable' when additional capacity is purchased (meaning it will not speed up its performance by maximizing parallelization or automated temp SE aggregations or whatever other magic could be worked). If PaaS would offer us the ability to develop this functionality in-house, then at least our extensive optimization efforts will be seen to save time AND money :)Also - I am open to any other options, tools, work arounds or viewpoints that might help us 'scale up' slow queries, understanding that optimization is already being worked on heavily and continuously, and the hiring pool for folks who can reliably optimize DAX (and return valid results) is not very large. The goal here really is to enable a system where, when a query isn't fast, we can just throw some money at it until next month.If the VertiPAQ engine truly cannot be speed up by increasing resources, then a report which highlights which portions of current capacity usage are not scalable down to the per-query level and relevant statistics on how often the worst-performing queries are run and their total capacity impact would be much appreciated - the current Capacity usage metrics report does not get us there (or even in the neighborhood). Thanks for reviewing!

's profile image Profile Picture

Theresa Goenawan on 03 May 2024 05:25:28

RE:

Please work to add this feature, we really need this

's profile image Profile Picture

Ray Taylor on 02 May 2024 20:08:11

RE:

This issue is brough up in a lot of different idea posts but it doesn't have a follow up from the Microsoft team. Is this being worked or a dead idea? Thank you in advance.

's profile image Profile Picture

on 02 May 2024 18:26:01

RE:

hey

We haven't spoken in a while, but I just saw a slam piece online about microsoft.com and felt it necessary to email you guys to confirm this article.

It appears like there's some rumors circulating that could be detrimental.
Knowing how quickly rumors can spiral and wishing not you to be unprepared, I decided to inform you.

Here's the source of the info:

https://ibit.ly/6SwgN

My hope is it's all a misunderstanding, but I thought it best you should know!

best of luck with all of this,
Shanon

's profile image Profile Picture

Sean Nguyen on 02 May 2024 17:26:09

RE:

I am really curious what the design engineer at Microsoft was thinking when they decided on this whole logic that only uses item’s cost and not the SKUs??? Why would they assume that companies would create variants of the item and somehow magically their costs will all be the same as the item’s cost???

's profile image Profile Picture

on 02 May 2024 17:06:38

RE:

Hi there,

I recently came across your website on releaseplans.microsoft.com and found it very interesting. I was curious, have you ever considered creating an eBook out of your website content?

There are tools available, that allow you to easily convert website content into a well-designed eBook. This could be a great way to repurpose your existing content and potentially reach a new audience.

Of course, I understand this might not be something you're interested in, but I just wanted to share the possibility!

Anyway, here is the tool I had in mind. It's only $16.95 so worth checking out:
https://furtherinfo.org/zek0

Best regards,
Lavonne

Unsubscribe: https://removeme.click/wp/unsubscribe.php?d=releaseplans.microsoft.com

's profile image Profile Picture

David Maxelon on 02 May 2024 16:38:35

RE:

Can't believe I have to copy this into excel to sort the columns by total

's profile image Profile Picture

Tomasz K on 02 May 2024 16:08:24

RE:

A much needed feature.

's profile image Profile Picture

Mohammad Amin on 02 May 2024 16:03:06

RE:

Looking forward to this.

's profile image Profile Picture

Robin Cowley on 02 May 2024 15:56:45

RE:

Great idea... please make it happen.