Forum Discussion
Capturing User Information from MdxQuery events in Log Analytics
I'll ask around. We have the same problem with our finance users. They have discovered that they can use CUBEMEMBER etc functions and are doing that excessively, leading to thousands of concurrent MDX queries from a single Excel file (for example) which make the capacity rather sad. You may want to plan for the re-education sessions already.
thank you.
we've already had several discussions w/ the "report builders" on the dos/don'ts w/ the dataset (i.e. "don't use a bunch of giant pivot tables to dump data from the PBI dataset, we can provide you with whatever extract you need using a more appropriate method")
Let me know what works for you. We are having a hard time fighting the stubborn. Short of cutting their Power BI access there's nothing you can technically do in the tenant/capacity.
nothing to do but communicate (which can be challenging depending on the organization's data maturity)... as an advisor, i just provide the options, tradeoffs, and opinions... it's up to the client to decide what (if anything) to do about the issue(s)