cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate IV
Advocate IV

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support
Community Support

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

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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?

hi, @Renaud 

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

 

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors