Forum Discussion

andreame's avatar
andreame
Frequent Visitor
1 year ago
Solved

Big Discrepancies between Service and Desktop

Hi Everyone,

 

I have an issue which I am facing since a few weeks and I haven't been able to solve.

I have a measure that calculates the Backlog in production orders at a specific point in time. Here is the measure:

BacklogProduction =
VAR CurrentDate = MAX('Datum Copy'[Date])
RETURN
CALCULATE(
    DISTINCTCOUNT('Sales Lines (+Arc)'[prodOrderNo]),
    FILTER(
        ALL('Sales Lines (+Arc)'),  
        'Sales Lines (+Arc)'[orderDate] <= CurrentDate &&
        'Sales Lines (+Arc)'[EndingDate] >= CurrentDate 
    )
)
 
When I publish it on my workspace and access it from the Cloud version of PowerBi, the results are correct until the first scheduled refresh. After the first scheduled refresh, the numbers are completely different.
Here I post screenshots of the 2 different results (Top is the Desktop version, bottom is the Service)

 



Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi andreame ,

    1. Verify Data Source Credentials and Privacy Levels - Ensure the Power BI Service is connecting to the correct data with consistent privacy settings.

    2. Sometimes partial or silent refresh errors cause unexpected results. Check refresh history under your dataset settings.

     

    If the issue continues even after checking all the above aspects, I recommend raising a support ticket with Microsoft for a deeper investigation.

    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

     

    Thank You.

6 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    1 year ago

    Hi. Make sure to refresh your power bi desktop before publishing to service in order to check the data and visualizations are up to date. Once you do it and publish, check the visual filter context in the icon on the top right corner that appears when you mouse over it to make sure you don't have any additional filter saved from a previous version.

    I hope that helps,

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi andreame ,

    Thank you for your inputs, ibarrau.   I’d like to suggest a few additional troubleshooting steps that might help.

    1. Always refresh your dataset in Power BI Desktop before publishing to ensure the data matches what’s loaded to the Power BI Service.
    2. Ensure the Datum Copy table is properly marked as a Date Table in your model. If it’s not, DAX time intelligence functions like MAX(Date) might behave unpredictably after publishing.
    3. Remember that Power BI Desktop uses your local time, whereas the Power BI Service operates in UTC. This difference can cause mismatches in time-sensitive data (datetime values) after a refresh.

     

    If my response solved your query, please mark it as the Accepted solution to help others find it easily.

    And if my answer was helpful, I'd really appreciate a 'Kudos'.

  • andreame's avatar
    andreame
    Frequent Visitor
    1 year ago

    Hi V-yubandi-msft ibarrau ,

     

    Thanks for your help.

    1) I refreshed the Desktop version after publishing but the results are still there. 

    2) Thanks for the suggesion, I marked it as date table. 

    3) I know that there might be smaller differences due to the local time vs UTC. However, I don't think it's the case here. We are talking about very big gaps between the two versions.

     

    Unfortunately I tried your suggestions, but they didn't solve the problem

    • V-yubandi-msft's avatar
      V-yubandi-msft
      Community Support
      1 year ago

      Hi andreame ,

      1. Verify Data Source Credentials and Privacy Levels - Ensure the Power BI Service is connecting to the correct data with consistent privacy settings.

      2. Sometimes partial or silent refresh errors cause unexpected results. Check refresh history under your dataset settings.

       

      If the issue continues even after checking all the above aspects, I recommend raising a support ticket with Microsoft for a deeper investigation.

      How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

       

      Thank You.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi andreame ,

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

    Thank you.

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    1 year ago

    Hi andreame ,

    We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

    If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

    Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

     

    Thank you for your understanding and participation.