Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Local meaures on report with shared dataset

Hi , is there anyway to organise locally where measures are created. The central model has measure tables and folders. Can more be created locally? How can we easily identify local measures? Also if a...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the suggestion , but no that deosnt seem possible in a report using a differant power bi dataset. The option is greyed out.

 

I could build in blank folders etc in the dataset of local report writers using them. But thats far from ideal as I wont know who may set up a report on it.

 

Also the idea of how I go about centralising measures again and possible name conflicts still is a question?

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

hi  Anonymous 

When you conect to a shared power bi dataset, it is a live connection model.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets#limitations-and-considerations

 

So the only modeling that you could only create report level measure in this report.

 

For the same name measure, it could not achieve in power bi, I think add a flag in the measure name is a good way.

 

Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks - I tested the measure with the same name. So any measure created centrally with teh same name as a local measure, results in the local one breaking. So visuals using it no longer work. You must delete the local measure to use the central one.

     

    Looks like naming conventions and or a  centrally added table or folder for local variables may be needed. Thanks