Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
ssuzjzuss
Frequent Visitor

The display of Power BI Desktop and Power BI on the web is not the same.

Hi,

 

I have an issue where the data in Desktop works correctly, but when I publish it to the service, the data displays differently than in Desktop. How can I go about resolving this?

 

Desktop (Work correctly):

bi-problem-1.png

 

Web:

bi-problem-2.png

 

Same data / Same filter / Same logic / Refresh at the same time

1 ACCEPTED SOLUTION
ssuzjzuss
Frequent Visitor

Thanks all.

 

I have successfully resolved it. The issue was related to time and date formats, such as dd/mm/yyyy or mm/dd/yyyy. My solution involved using the FORMAT function within a DAX expression to address this.

View solution in original post

3 REPLIES 3
ssuzjzuss
Frequent Visitor

Thanks all.

 

I have successfully resolved it. The issue was related to time and date formats, such as dd/mm/yyyy or mm/dd/yyyy. My solution involved using the FORMAT function within a DAX expression to address this.

Anonymous
Not applicable

Hi  @ssuzjzuss ,

 

Are you using a function like Now() in a formula where the time display of the Power BI service is different from the time display of the Power BI desktop.

The time in Power BI Desktop is determined by the system time set in your local computer.

The time in Power BI Service is based on the time zone of the place where your data exists.

The data storage location can be found in the Power BI Service under the "?" logo, click on it and then About Power BI at the bottom.

vyangliumsft_0-1696222233464.png

 

Best Regards,

Liu Yang

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

lbendlin
Super User
Super User

Power BI Service runs on UTC.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.