Want to create Calculated columns in Power bi desktop with Power bi dataset connection

[AshDil]

Hi,

I have connected to Power bi dataset from Power bi desktop. 

Now, I want to create as some calculated columns and transformations on that dataset. But I see all are disabled.

Please help me to do it.

Please let me know the advantages and limitations of connecting to Power bi datasets.

Thanks,

AshDil.

[amitchandak]

@AshDil , I doubt you can add calculated on a live connection 

[AshDil]

Hi @amitchandak ,

I'm not able to see whether the connection is live or import for Power bi dataset.

Please help me to know how to deal with power bi dataset.

Thanks,

AshDil

[v-zhangti]

Hi, @AshDil 

The Power bi Desktop connection to the Power bi dataset is a live connection. Unable to create calculated columns, you can try to create Maesure.

The following link can be consulted for more information about the processing and limitations of the Power bi dataset.

https://docs.microsoft.com/power-bi/connect-data/desktop-report-lifecycle-datasets 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.