Local meaures on report with shared dataset

[Anonymous]

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 local measure was needed to be shared, how would be transfer it to the central model. Just type it in again? Would then a local measure called # Calls cause problems is the central model had a measure called # Calls added. Hopefully that makes sense and someone has a good solution they use. Thanks very much for your time reading the problem I have.

[amitchandak]

@Anonymous , just check if this possible in power bi Dataset

in the model view, you can create a subfolder

https://www.youtube.com/watch?v=b9oDIL8nbu0&list=PLPaNVDMhUXGYrm5rm6ME6rjzKGSvT9Jmy&index=3

[Anonymous]

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 · Accepted solution]

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]

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