Measures added to a powerBI dataset do not appear in analyse with excel

[Renaud]

When creating (with powerBI desktop for example) a new report from an existing dataset, and adding a measures (not existing in the original dataset) and publishing that new report, the analyse in excel function does not show the new measure. 
Is it a bug?

[v-lili6-msft · Accepted solution]

hi, @Renaud

It is not a Bug, I get this from PG at the moment:

This is current Analyze in XL behavior. When doing Analyze in XL we are connecting to a dataset and not to a report so for the measure to appear in AIX it should be in the dataset.

When connecting to the dataset from Desktop and creating a report with new measure the connection to the dataset is read only connection and the measure is added to the report only.

Best Regards,

Lin

[Renaud]

Thanks @v-lili6-msft for your answer, I understand the logic behind. I'll think whether to submit an idea to enhance that.
But at the same time, I am thinking the best way to deal with this would probably to allow "Analyze in XL" to connect to a PowerBI dataset and add measures locally, just like it can be done in PBI service or PBI desktop. Is this anywhere on the roadmap?

[v-lili6-msft]

hi, @Renaud 

For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner .

Best Regards,

Lin

[v-lili6-msft]

hi, @Renaud 

I could reproduce the same result, I have submitted it to PG.

will update here once I get any information.

Best Regards,

Lin