The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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?
Solved! Go to 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
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
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
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
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.