Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

lqian

numerical data gets multiplied by 100 when auto-refreshing in Power BI server

Submitted by on ‎06-26-2023 01:04 AM

I have a column containing data like this: 8.50, 8.00, 0.00, etc. I published it on the Power BI server My Workplace. I set an auto refresh using the gateway. After refreshing, my data changed to 850, 800, 0, etc. 

 

I tried to align my .pbix file's regional settings with the server account's regional settings. It doesn't work. 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎06-28-2023 04:52 AM

Hi @lqian ,

 

This issue is likely caused by a difference in the regional settings between your local computer and the Power BI server. When you publish a report to the server, it uses the regional settings of the server to display numbers and other data types.

To resolve this issue, you can try the following:

1. Change the regional settings in your .pbix file to match the regional settings of the Power BI server. To do this, go to File > Options and settings > Options, and then select Regional Settings. Make sure the settings match the server's regional settings.

2. Use the FORMAT function in your DAX formulas to format the numbers in your report. For example, you can use the FORMAT function to display the numbers with two decimal places: FORMAT([MyColumn], "0.00").

3. If the above solutions do not work, you can try changing the data type of the column to "Text" before publishing the report. This will prevent the server from automatically converting the numbers to a different format.

It's also worth noting that when you set up the auto-refresh using the gateway, the regional settings of the gateway may also come into play. Make sure the regional settings of the gateway match the regional settings of the server as well.

 

Best regards.
Community Support Team_Caitlyn

Idea Statuses