Forum Discussion
Creating Measures in Report
Hi community,
Hope you all are doing well.
I have a doubt regarding Power BI Service.
I know there's an option to Create a report in Power BI Service via Excel or an already published Dataset.
we can create visuals, and apply aggregations but can we create measures in the report? that's my main concern
Because I tried everything but couldn't find an option to create a measure in the Power BI Service report.
Please help.
Hello,
I think you need to activate Edit Data model in Power bi service
https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-models
Anonymous
Thank you so much, I found it.
But I've 1 doubt regarding this, hope you can help me out there.
why is the Open model option not activated? in few datasets it was activated and I could create measures, but why not in this one??
I've activated the Edit option too in workspace settings.
Niraj_vora0106 - In the workspace settings, you need enable the option "User can edit the data models in Power BI Service". Hope this helps.
Did I answer your question? Mark my post as a solution!
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
4 Replies
Hello,
I think you need to activate Edit Data model in Power bi service
https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-models
Niraj_vora0106 - In the workspace settings, you need enable the option "User can edit the data models in Power BI Service". Hope this helps.
Did I answer your question? Mark my post as a solution!
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Anonymous
Thank you so much, I found it.
But I've 1 doubt regarding this, hope you can help me out there.
why is the Open model option not activated? in few datasets it was activated and I could create measures, but why not in this one??
I've activated the Edit option too in workspace settings.
Have you looked at the limitation section to see if you match any of these: https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-models#unsupported-datasets