Moving measures from a dashboard with "Live" datasource to another dashboard

[WBADAM03]

Hey there,

My predecessor created a dashboard with a table full of measures in an older dashboard. I need to recreate the report with a new dataset and I'd like to reference the old measures in my new report. 

I am having trouble getting the DAX from the old reports to help me recreate them with a new data warehouse. 

My predecessor seems to have made a "live connection" dashboard and data view is completely disabled. 

I turned on "performance anaylzer" and messed with the slicer and got some DAX code, but it doesn't paint a good enough picture.

Does anyone know of a way that I can make a "Live dashboard" stop being live or a way to enable me to view the specific DAX for the table of measures? 

I am unclear why anyone would ever want to have a "live" datasource if it blocks out so much and makes it much harder for people to inherit a project.

[cassidy · Accepted solution]

Your predecessor did the right thing, in my opinion, which is to create a Dataset with all of your Measures and then build Reports using a Live Connection to that Dataset.  This helps ensure that all critical Measures are part of the Dataset, rather than living in random reports.  It also prevents having to manage a singular Dataset per Report scenario. 

If you click on the Measure in the fields list in your Report and the DAX bar does not show how it was created, that means the Measure lives within the Dataset.  You need to open the Dataset and click the Measure and it will reveal the DAX.

[WBADAM03]

Thanks! That makes sense.

This is the first time I encoutered a live connection in a dashboard, everything else I inherihted (and experimented with) were not live connections.