Forum Discussion

SQLbyoBI's avatar
SQLbyoBI
Icon for Advocate I rankAdvocate I
4 years ago

Capturing User Information from MdxQuery events in Log Analytics

Is it possible to see the end user associated with an MDX query events captured in Log Analytics attached to a Power BI (premium) workspace?   Currently working w/ a client where we've attached Log...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.

SQLbyoBI's avatar
SQLbyoBI
Icon for Advocate I rankAdvocate I
4 years ago

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