ISSUE - No longer able to view Measure code in Live Dataset

[MarkSL]

Hi ,

We have many reports which have been built on a Power BI Live Dataset.   These reports contain measures which are unique to the report and so have been added in the PBIX of the report, so we have a mix of measures from the Live Dataset and measures in the PBIX.

Today we have found that we are now unable to view the code of these measures added to the PBIX?  I can see the measure listed, but Desktop is not opening up the window to show me the DAX?  This was always the case with measures belonging to the Live Dataset, but not for custom ones added to the PBIX.

The following test fails for me:

Create new PBIX

Connect live to Power BI Dataset

Create test measure, eg:  'TEST' = SUM(SALES_)

At this point I can see my DAX code.

Close the PBIX

Re-open the PBIX

Click on TEST measure and I can no longer see the DAX code.

This is a really big issue for us.  Is anyone else seeing this?  The issue was not present yesterday.

Issue is present on two versions of Desktop:

Version: 2.98.882.0 64-bit (October 2021)

Version: 2.98.1004.0 64-bit (October 2021)

Thanks

Mark

[MFelix]

Hi @MarkSL ,

I have made the same test and the result is the same, you should place this on the issue part of the forum.

https://community.powerbi.com/t5/Issues/idb-p/Issues

[MarkSL]

Its a weird one. about 30 minutes after creating this post, the DAX window suddenly appeared again in the PBIX (without us refreshing or opening / closing the file), so we thought something in the service has been fixed.  But then it went back to locked again...

We've raised a support ticket and already had a call with MS.  Waiting to see what they come back with.  This can't be desired behaviour - the recommended way to develop Power BI reports is to have a central data model and to then create reports of that Live Dataset. 

We can't be expected to create every custom measure required for a specifc report need in the main data model.

Really hope it is fixed ASAP!  

[MFelix]

Hi @MarkSL ,

In previous versions this did not worked like this, so believe is a bug, they will solved it ASAP for sure, this is a big requirement for everyone to reuse datasets.