topic Re: Quick Measure, What Data is Sent? in DAX Commands and Tips

Quick Measure, What Data is Sent?

AStaUK — Mon, 25 Sep 2023 20:38:50 GMT

I work as a System Admin and have been asked to look at enabling Quick Measure for one of our analysts to assist with generating DAX commands. This is fine, but I see that Microsoft disable this feature by default because it transfers data out of the EU to the US, does anyone know what data is sent and is there anywhere in Microsoft land where this is documented?

I've hunted high and low and can't seem to find anything specific about how this feature works. Logically it sounds like it's taking the query sending it to a LLM which generates the command, but is it sampling and sending any of data that's contained within the data set, i.e is potentially sensitive/personal data being sent outside of the EU to the US?

Re: Quick Measure, What Data is Sent?

lbendlin — Tue, 26 Sep 2023 18:58:54 GMT

I don't think the standard Quick Measure feature reaches out anywhere. You are probably referring to the "Suggestions with CoPilot" which can be seen as an extension of Q&A and does require data to travel. This link gives a couple clues Data sources for natural language Q&A - Power BI | Microsoft Learn

Re: Quick Measure, What Data is Sent?

AStaUK — Tue, 26 Sep 2023 21:57:17 GMT

This is what I'm looking at, https://learn.microsoft.com/en-us/power-bi/transform-model/quick-measure-suggestions when enabling the function in PBI Admin it warns you that data will be sent outside of the EU to the US to be processed, it's at the bottom under Limitations and Considerations.

Re: Quick Measure, What Data is Sent?

lbendlin — Tue, 26 Sep 2023 23:16:45 GMT

yeah, we disabled that setting (allow data to leave the country) on our tenant.

Re: Quick Measure, What Data is Sent?

AStaUK — Wed, 27 Sep 2023 20:26:55 GMT

Interesting, why did you decide to disable it? In our use case it's to assist our junior BI analysts in creating DAX commands for use with reports.

Re: Quick Measure, What Data is Sent?

lbendlin — Wed, 27 Sep 2023 20:32:20 GMT

for the same reasons as what you mention in your original post.

The regular quick measures and https://daxpatterns.com are sufficient to get your junior BI analyst going. If they need more, tell them to read the articles on sqlbi.com. Any article will do, they are all good.