Creating measures on Tabular SSAS Live connection: where are they stored?

[OneWithQuestion]

With the new feature that was released

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/#reportLevelMeasures

Where are these measures stored?

It says they are NOT part of the model, so are they sort of like a DAX query that is just executed from the report?

If I update an underlying field that is referenced what happens?

What if a query does a massive Cartesian product, will it use up all the server RAM?

Who is allowed to create them, anyone or is there a specific security role required?

It is a GREAT feature, I just want to better understand all the implications, thanks!!!

[v-shex-msft]

Hi @OneWithQuestion,

>>Where are these measures stored?

There measure store in pbix file.

>>It says they are NOT part of the model, so are they sort of like a DAX query that is just executed from the report?

The document mentioned: "they will behave just like measures defined in imported models", so this will similar as offline database and these measures only work on the cached data.

>>What if a query does a massive Cartesian product, will it use up all the server RAM?

In my opinion, it will spend the RAM of the current pc which running the power bi desktop.

>>Who is allowed to create them, anyone or is there a specific security role required?

People who has the permissions to access the tabular ssas database can get data from database and create the measure.(it will similar as normal ssas datasource, reference link: Connect to SSAS Multidimensional Models in Power BI Desktop)

In addition, you can refer to below comment from Will "Thompson" :

We'll have a full doc page up shortly, but to answer your question - we're passing the report measure through in the queries that get sent to the SSAS server. It's just like someone connecting Excel or SSMS to the AS model and running queries today - including security etc. You can hook up profiler and see the queries being run. I'm working on a template that you can use to look at your AS logs and extract the report measures that are being run against the server to help identify any common (or spurious!) measures... Will blog about that soon!

Regards,

Xiaoxin Sheng

[OneWithQuestion]

With the new feature that was released:

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/#reportLevelMeasures

Where are these measures stored?

It says they are NOT part of the model, so are they like a DAX query that is just executed from the report?

IF I update an underlying field that is referenced what happens?

What if a query does a massive Cartesian product, will it use up all the server RAM?

Who is allowed to create them, anyone, or is there a sepcific security permission required?

It is a GREAT feature, I just want to better understand all the implications, thanks!