Transform Data option greyed out

Question

Hi&nbsp;When I click on a measure in a PBI report that was shared with me (I am an assigned Owner), I cannot view the formula at all. When I checked under Options and Settings, the "Display Formula Bar" is checked, yet I cannot view the formula.&nbsp;Then I noticed that my Transform Data option is greyed out - see screenshot attached.&nbsp;Are the 2 issues related?How can I enable my Transform Data option and also view the Formula?ThanksAisha

greg_deckler · Answer

aishayeoh&nbsp; - Are you possibly using a Live connection to a Power BI dataset in this report (versus import mode for example)

aishayeoh · Answer

Hi Greg, thanks. I didn't create this report but I see that several measures were created.&nbsp; Is it possible to connect live only but still be able to create measures? Thanks.

v-lianl-msft · Answer

Hi aishayeoh&nbsp;,&nbsp;Measure can be created by live connection, or you can download this pbix file from service.&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Transform Data option greyed out

3 Replies

Related content

Real time data transformation options

Table Transformation

Export data option greyed out

Transform data greyed out

Transform columns / type