Data Difference in Desktop and Web

[wpretz]

Good afternoon.

I have this problem: In my desktop version I generated a pvix with data within a SharePoint. But after you publish it to the web and the web automatically updates the dataset, the details about values are distorted. Who knows why?

[Syndicate_Admin]

Hello! Something similar happens to me, I update the exchange rate of a currency through an API and in the desktop there is the number with a decimal separator with a comma, but in the Powrr Bi web with the automatic update it brings it to me with a decimal separator with a period... How did you change the formatting in the dataset? Thank you!

[wpretz · Accepted solution]

Good morning

Thank you for your answers.

I was able to fix the problem. The error was because desktop had a column with values and texts. But when you passed the Dataset to the web they assumed the text format and generated the extrabagrant numbers.

Best regards!

[amitchandak]

@wpretz , Hope you have not setup a schedule at power BI service level? or is your power bi file is stored at one drive or share point?

If yes that is possible.

refer this : https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive

[mhossain]

@wpretz 

Do you mean scheduled refresh not working for you after publishing? Have you checked refreshing manually, is it showing the latest numbers?