Power BI services dashboard different Power BI desktop dashboard

[Seb_Bonnet]

Hello

I am using Power BI desktop to analyze some data from JIRA tool.

For this, I installed a Power BI connector on JIRA.

The dashboard refresh on Power BI desktop works very well. I published this dashboard on Power BI Services and scheduled refresh each days.

I am encountering an issue. I don't have the same result in Power BI Desktop and Power BI Services after refresh.

This issue appears on a new measure whose formula is:

Days_actual_Worklogs_Adjusted = 
IF(
    'Worklogs'[LOGGED_TIME] / (8 * 3600) > 0;
    'Worklogs'[LOGGED_TIME] / (8 * 3600);
    1 / 8  // Correspond à 1 heure de travail minimum
)

It seems this formula does not work in the same way between Power BI Services and Power BI Desktop.

Could you please support me to solve this issue?

Thanks

Sébastien

[v-tsaipranay]

Hi @Seb_Bonnet ,

Thank you for reaching out to the Microsoft fabric community forum. Also thank you @Akash_Varuna  for your inputs.

The difference you're seeing between Power BI Desktop and Power BI Service is likely due to timezone differences Power BI Desktop uses your local time zone, while Power BI Service runs in UTC.

To align results, check if LOGGED_TIME from JIRA is in UTC.

• If so, adjust it by adding your local time offset in a calculated column. For example, for CET (UTC+2):

LOGGED_TIME_Adjusted = 'Worklogs'[LOGGED_TIME] + TIME(2, 0, 0)

• Update your measure to use this adjusted field.

Also, confirm your dataset refreshes correctly via the gateway and that both environments are loading the same data version.

I hope this will resolve your issue, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thankyou.

[v-tsaipranay · Accepted solution]

Hi @Seb_Bonnet ,

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.

[Akash_Varuna]

@Seb_Bonnet Ensure there are no time zone differences between Power BI Desktop and Power BI Services. Check that both environments are using the same data version and that Power BI Services is updated after each refresh. Review regional settings that might affect the formula's calculation. Lastly, verify the custom JIRA connector works the same way in both environments.

[Seb_Bonnet]

Hi @Akash_Varuna 

Thank you for your feedback.

I checked the regional ssetings and I have the same configuration on the 2 dashboards.

Regarding the time zone, could you please give me guideline to check it.

For JIRA connector, I think it works the same way in both environments.

Thanks