cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Michaelbean21
Advocate I
Advocate I

Report refreshes properly in Desktop but not in Workspace

I have a PowerBi report that works just fine in my desktop, it refreshes and operates as I would expect.  However, after I upload it to the workspace and then it refreshes while exisiting in the workspace the report nulls out my data.

Has anyone encountered this issue?  Normally if I have an issue in the workspace it is always an issue in the desktop also, however it is not the case this time.

1 ACCEPTED SOLUTION
Duia
Resolver II
Resolver II

Hi  @Michaelbean21 ,

You can view refresh details in Refersh history

View data refresh history for Power BI reports – Support (zendesk.com)

1. Is there a date function for Now() or Today() in your dax function? Because Power BI Service uses UTC(), and Power BI Desktop uses your computer's local date, so the data may be Filter out and not show.

https://community.powerbi.com/t5/Desktop/Different-data-between-Power-BI-Desktop-and-Power-BI-Servic...

2. Reset all filters on your report.

3. It is also related to the gateway you configure, such as.

Verify that you have the correct username and password.

Your data source credential may expire, so try to update the credential and republish the report. 

Check out this link for details:

https://community.powerbi.com/t5/Service/Dataset-Refreshes-but-Report-Does-not/m-p/1202237

 

This is the related document, you can view this content:

Power BI Data Refresh Works in Desktop but not Onl... - Microsoft Power BI Community

https://community.powerbi.com/t5/Service/Refresh-fails-on-online-service-but-works-in-desktop-versio...

https://community.powerbi.com/t5/Service/refresh-error-in-service-not-in-desktop/m-p/1912538

 

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.

View solution in original post

2 REPLIES 2
Duia
Resolver II
Resolver II

Hi  @Michaelbean21 ,

You can view refresh details in Refersh history

View data refresh history for Power BI reports – Support (zendesk.com)

1. Is there a date function for Now() or Today() in your dax function? Because Power BI Service uses UTC(), and Power BI Desktop uses your computer's local date, so the data may be Filter out and not show.

https://community.powerbi.com/t5/Desktop/Different-data-between-Power-BI-Desktop-and-Power-BI-Servic...

2. Reset all filters on your report.

3. It is also related to the gateway you configure, such as.

Verify that you have the correct username and password.

Your data source credential may expire, so try to update the credential and republish the report. 

Check out this link for details:

https://community.powerbi.com/t5/Service/Dataset-Refreshes-but-Report-Does-not/m-p/1202237

 

This is the related document, you can view this content:

Power BI Data Refresh Works in Desktop but not Onl... - Microsoft Power BI Community

https://community.powerbi.com/t5/Service/Refresh-fails-on-online-service-but-works-in-desktop-versio...

https://community.powerbi.com/t5/Service/refresh-error-in-service-not-in-desktop/m-p/1912538

 

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.

ronaldbalza2023
Super User
Super User

Hi @Michaelbean21 , may I know if there's an error message? If so, what does it says?

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors