cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Michaelbean21
Frequent Visitor

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
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors