Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Adding Calculated Column in Shared Dataset

Hi,   I'm using a common dataset published in Power BI Service and want to create multiple reports based on it. So far I didn't find any way to add a calculated column or anything similar in my rep...
Need Help
Tips and Tricks
Tutorial Requests
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    You need to ask the own of the the dataset to add a column or measure in original dataset in power bi desktop.  you use a shared dataset to create a report, that means you are using a live connection, you could only create a report level measure.

     

    Regards,

    Lin

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

hi  Anonymous 

You need to ask the own of the the dataset to add a column or measure in original dataset in power bi desktop.  you use a shared dataset to create a report, that means you are using a live connection, you could only create a report level measure.

 

Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Greg_Deckler, v-lili6-msft thank you for your answers this is clear to me now, it makes sense shared dataset forces use of live connection. Is there any workaround to that? Any possibility to create report level copy of the model and then add the calculated columns?

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    hi  Anonymous 

    No workaround for now, you could only create a measure in your side, if you want to create a column in the dataset, you need to add it in original dataset, 

     

    Regards,

    Lin