lqian's avatar
lqian
New Member
3 years ago
Status:
Investigating

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

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...
Data Modeling
Gateways
Report Server
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

Completed Ideas