cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MoOv Regular Visitor
Regular Visitor

Refreshing in PBI Service changes data significantly

Hello everybody,

 

I am having issues with one of my datasets. I did some minor changes on it for a report I wanted to build; afterwards I published the dataset. At first there was no problem, I built the report and published it - but when the dataset had refreshed in PBI Service, the data changed significantly: the report displays percentages, and some of those increased by a magnitude of 10^14 - but only some, not all of them. Others did apparently not change at all, and the rest changed by a magnitude of 10^1. My first thought was that there had to be issues with the data I am using; but, when I refresh the dataset locally (i.e. the .pbix on my laptop) and re-publish it, I get the correct values again. That is, until automatic refresh in PBI service has completed. And this is exactly what I do not understand: Where is the difference in whether the dataset is refreshed locally or via PBI Service? To my understanding there should be no difference at all. Has anybody experienced a similar issue and can help me out? I am totally clueless about this.

 

Thanks in advance,

Moritz

1 ACCEPTED SOLUTION

Accepted Solutions
MoOv Regular Visitor
Regular Visitor

Re: Refreshing in PBI Service changes data significantly

Hello @v-cherch-msft,

 

thank you for answering. I was able to resolve the problem by now: I did not format the column containing the data in the query editor. When loaded into the dataset, it was auto converted to a text value - I do not know why this did not cause problems in PBI Desktop as one would expect, but only after refreshing via Service; anyway, properly formatting the column resolved the issue.

 

Regards

Moritz

2 REPLIES 2
v-cherch-msft Super Contributor
Super Contributor

Re: Refreshing in PBI Service changes data significantly

Hi @MoOv 

Which data source did you use?For further,i would suggest you have a look at below articles.

https://docs.microsoft.com/en-us/power-bi/refresh-data

https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-local-drive

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MoOv Regular Visitor
Regular Visitor

Re: Refreshing in PBI Service changes data significantly

Hello @v-cherch-msft,

 

thank you for answering. I was able to resolve the problem by now: I did not format the column containing the data in the query editor. When loaded into the dataset, it was auto converted to a text value - I do not know why this did not cause problems in PBI Desktop as one would expect, but only after refreshing via Service; anyway, properly formatting the column resolved the issue.

 

Regards

Moritz

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 416 members 4,349 guests
Please welcome our newest community members: