Forum Discussion
Date Column Shows Time in Power BI Report Even After Converting to Date in Dataflow Gen2 (Fabric)
Hi Parth_1 ,
Thank you for reaching out to Microsoft Fabric Community.
In Power BI Service, the experience is different from Power BI Desktop. In Power BI Desktop you have full control over editing measures, applying formatting and performing calculations directly within the report or data model. However in Power BI Service (or Fabric), that flexibility is more limited. While you can interact with and view reports in the Service, editing measures, formatting them, or applying specific measure tools (like rounding) is typically only possible in Power BI Desktop. To make any changes to measures or calculations in Power BI Service, you would need to first make those changes in Power BI Desktop and then republish the updated model to the Service.
Regarding the issue of not being able to create a new column in your existing table, this is also linked to the environment settings. In Power BI Desktop you can easily create calculated columns because you are directly working with the data model. But in Power BI Service creating new calculated columns is generally not allowed unless you are working in a Premium capacity workspace or the model has been configured to allow this in the service. To enable this functionality you will need the appropriate permissions and the dataset must be set up to allow changes. Without these creating calculated columns directly in Power BI Service won’t be possible.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hi lbendlin,
Really appreciate your quick turnaround.
I am trying to perform some calculations with same semantic model, In that I am facing some issues.
1.Unable to view measure tools setting
Case : I want to roundup the value of my KPI which highlighted here , In desktop we are having option to edit the measure also some formatting setting in Measure tool , but in fabric I am unable to view that setting.
Whereas In desktop I am able to access the measure tools setting.
2. Can't able to create new column in my existing table
I am trying to create one calculated column in existing table but the option is disabled.
Thank you once again for your swift and kind response
You mentioned DF Gen2. What exactly are you connecting to here? The Default Semantic model of the data warehouse?
Hi Parth_1 ,
Thank you for reaching out to Microsoft Fabric Community.
In Power BI Service, the experience is different from Power BI Desktop. In Power BI Desktop you have full control over editing measures, applying formatting and performing calculations directly within the report or data model. However in Power BI Service (or Fabric), that flexibility is more limited. While you can interact with and view reports in the Service, editing measures, formatting them, or applying specific measure tools (like rounding) is typically only possible in Power BI Desktop. To make any changes to measures or calculations in Power BI Service, you would need to first make those changes in Power BI Desktop and then republish the updated model to the Service.
Regarding the issue of not being able to create a new column in your existing table, this is also linked to the environment settings. In Power BI Desktop you can easily create calculated columns because you are directly working with the data model. But in Power BI Service creating new calculated columns is generally not allowed unless you are working in a Premium capacity workspace or the model has been configured to allow this in the service. To enable this functionality you will need the appropriate permissions and the dataset must be set up to allow changes. Without these creating calculated columns directly in Power BI Service won’t be possible.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
