Forum Discussion

Sander1401's avatar
Sander1401
Helper II
1 year ago
Solved

PowerBI Service changes year on refresh

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...

 

5 Replies

  • Deku's avatar
    Deku
    Super User

    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

  • v-achippa's avatar
    v-achippa
    Community Support

    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's avatar
      Sander1401
      Helper II

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

      • v-achippa's avatar
        v-achippa
        Community Support

        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