Forum Discussion
Number formatting differs between Power BI Desktop and Service (Indian comma format issue)
- 6 months ago
Thank you for confirming that you've already reviewed your browser settings. Since the issue remains after checking the regional settings in Power BI Desktop, Power BI Service, and your browser, the most effective solution is to rebuild the dataset from the beginning with the correct culture. Sometimes, even if you later update the model language to English (India), the dataset may still use the original culture set when the PBIX file was created. Because Power BI Service uses the dataset’s model culture for numeric formatting, it's best to close Power BI Desktop, reopen it with English (India) as the default model language, create a new blank PBIX file, reload your data, and republish the report. This will ensure the dataset is set up with the correct culture so numbers display in the Indian comma format (e.g., 12,34,567) in the Service.If you have any further questions, feel free to reach out and we'll be glad to assist.
Regards,
Microsoft Fabric Community Support Team.
- 5 months ago
Hi, the issue has not been resolved yet. I'm not sure who marked a solution for this post, but the problem still persists on my end.
Thank you for confirming that you've already reviewed your browser settings. Since the issue remains after checking the regional settings in Power BI Desktop, Power BI Service, and your browser, the most effective solution is to rebuild the dataset from the beginning with the correct culture. Sometimes, even if you later update the model language to English (India), the dataset may still use the original culture set when the PBIX file was created. Because Power BI Service uses the dataset’s model culture for numeric formatting, it's best to close Power BI Desktop, reopen it with English (India) as the default model language, create a new blank PBIX file, reload your data, and republish the report. This will ensure the dataset is set up with the correct culture so numbers display in the Indian comma format (e.g., 12,34,567) in the Service.
If you have any further questions, feel free to reach out and we'll be glad to assist.
Regards,
Microsoft Fabric Community Support Team.
Hi, the issue has not been resolved yet. I'm not sure who marked a solution for this post, but the problem still persists on my end.