Forum Discussion
Whole Number - Sematic Model
Hi CEllis ,
Thanks for confirming.
Yes, there can be differences between working in Power BI Service and Desktop, depending on how the semantic model is configured.
In Power BI Desktop, you have full control over the model, and numeric columns typically show the sigma icon and aggregation options as expected. In Power BI Service, this behavior can differ if the dataset is using a live connection, Direct Lake mode, or a shared semantic model, where some modeling properties are not fully exposed.
Since the behavior remains unchanged after refresh, I would suggest downloading the semantic model into Power BI Desktop (if that option is available), verifying the column data type and default summarization there, and then republishing.
Please reach out for further assistance.
Thank you.
Hi CEllis
When you click on the column in the data flow you should be able to see what the data type is and from what you are showing in your example it is showing it as a text field. Changes from text to whole number and see if that solves your issue.
