PowerBI Service changes year on refresh

[Sander1401]

Hi all,

have you ever seen this problem with PowerBI Service?
When I run my DataBricks SQL query I see normal birthdates, when I run my dashboard on PowerBI desktop, I see normal birthdates.
When I Publish my report to PowerBI Service, I still see normal birthdates. 
BUT... when I refresh the dataset, it changes the total birthdate... It doesn't hussle, but really changes, even when I make a string out of it. I also use a field of today, also a date, but that still works.
I cannot find any solution for it, has anyone seen this before? Clearing the cache doesn't help...

Situation after publishing, without refreshing the dataset:

Situation after publishing, after refreshing the dataset:

So in this example it changes 1908-09-03 into 7988-03-26, it looks totally random...

[v-achippa]

Hi @Sander1401,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Deku for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and give a kudos if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Sander1401]

No, this didn't solve the problem. For now I gave up...

[v-achippa]

Hi @Sander1401,

Thank you for the response, do you require any other assistance on this thread? If not we are closing this thread for now. If you have any further issue, please raise a new thread in the community forum, we are ready to assist you on it.

Thank you for being part of Microsoft Fabric Community.

Thanks and regards,

Anjan Kumar Chippa

[Sander1401 · Accepted solution]

you can close the thread

[Deku]

I assume that is a explicit measure. If you right click on the field in the visuals field well you should be able to set the summarization off. 

I assume in your original data you only have a single value, which sums to it's value, when you have more data it grows. If this is not the case have a look at the underlying data to ensure you have rows per each person, and nothing is happening prior to the data getting into power BI