Data Changes After Publishing Power BI Report to Web Service

[simonantony]

I'm experiencing an issue where my Power BI Desktop report (on an on-premise server) displays figures correctly, but after publishing to the Power BI web service and refreshing the dataset, the numbers change.

The dataset is linked to an Excel file, and the values are in decimal format (e.g., 1.0345). I suspect this might be due to a difference in regional settings between the on-premise server and the Power BI web service.

Has anyone encountered this issue before? Could the regional settings be affecting how decimal values are interpreted after publishing and refreshing?

I've attached screenshots for reference. Any insights or troubleshooting steps would be greatly appreciated!

Data Before:

Data After Web Refresh:

[v-tsaipranay · Accepted solution]

Hi @simonantony ,
I wanted to check if you had the opportunity to review the information provided. If the issue still persists, I suggest you please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-tsaipranay]

Hi @simonantony ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-tsaipranay]

Hi @simonantony ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

Can you build the report (new) in the Power BI Service and try to use the Edit Data Model (preview) in the service to open PowerQuery and look at the data?

[v-tsaipranay]

Hi @simonantony ,

Thanks for reaching out to the Microsoft fabric community forum.

I would also take a moment to personally thank @Anonymous , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

The Power BI web service probably uses different regional settings compared to your on-premise server, leading to misinterpretations of decimal values from your Excel data source. This issue often occurs when transitioning Power BI solutions between different environments.

The regional settings are likely the cause. Here is the detailed explanation:

• Power BI's regional settings affect how decimals are interpreted, with different regions using different separators (e.g., "." in the US, "," in Europe). Mismatched settings can misinterpret values in Excel files.
• Excel files adapt to the machine's regional settings, affecting how Power BI interprets the data depending on the refresh location.
• The issue arises after refreshing the dataset in Power BI, indicating a regional setting conflict during the cloud refresh process.

Here are a few steps you can take to troubleshoot and potentially resolve this issue:

• Ensure the regional settings in both Power BI Desktop and the Power BI web service are aligned. In Power BI Desktop, navigate to File > Options and settings > Options > Regional Settings. For the Power BI web service, go to Settings > General > Language and Region.
• Check that the data type and format of the decimal values in your Excel file are correctly configured. The issue might arise from the data type being interpreted differently after publishing. Make sure the locale settings in your Excel file match the regional settings in Power BI. Set the locale in Excel under File > Options > Language.
• If using an on-premises data gateway, the regional settings of the gateway server may also impact the data. Ensure the gateway server's regional settings are as expected.

Please refer to following documentation for detail information and considerable limitations:

Publish to web from Power BI - Power BI | Microsoft Learn

Additionally, I am including a similar thread that has already been accepted for your reference:

https://community.fabric.microsoft.com/t5/Desktop/Problem-with-Regional-Settings/m-p/310126

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

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

Thank you.

[simonandtony]

No luck

[Anonymous]

The first and second line appear correct, so I do not think it is a regional issue. I suspect the refresh in Power BI Service is pointing to a different excel file.

[simonandtony]

I have removed the connections to the old Excel files multiple times through Manage Connections and Gateways. After that, I have repeatedly published and replaced both the report and the semantic model, and I have also recreated the file connection to Excel from scratch multiple times. However, the data still changes after refreshing.

Is there something I might be overlooking or not updating correctly?