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
chicagolarsons
Frequent Visitor

Published Report vs. Desktop Report: missing data?

Hi Helpers,

I had something odd happen last night and cannot figure out what is causing it. I have prepared a report for a consulting manager who wants to understand the utilization of his team. I am querying against an data warehouse on an internal company server and against a dataset in the dataverse, and publishing the finished report to a sharepoint page on the company intranet.  But for some reason, the published report is missing data, and I cannot figure out why. In the screenshots below, you can see the report as it appears on my desktop, and you can see there are a lot more people listed in the top two tables. The second screenshot is from the published report. I published, and then clicked the link to open the published report, and that's it. I didn't change a thing. 

If anyone has any experience with this, I would really appreciate your insight on how to resolve this mystery. 

 

From Desktop:

chicagolarsons_0-1741271096869.png

From SharePoint:

 

chicagolarsons_3-1741271165658.png

 


 


 

1 ACCEPTED SOLUTION
chicagolarsons
Frequent Visitor

I have solved my problem, but I still don't understand why it happened. At the suggestion of a collegue, I created a new workspace and republished the report into the new workspace, and all the data was published correctly. Very strange, but maybe someone will find this tidbit helpful in the future.

View solution in original post

3 REPLIES 3
chicagolarsons
Frequent Visitor

I have solved my problem, but I still don't understand why it happened. At the suggestion of a collegue, I created a new workspace and republished the report into the new workspace, and all the data was published correctly. Very strange, but maybe someone will find this tidbit helpful in the future.

ray_aramburo
Super User
Super User

How long since you refreshed the data in the Power BI Desktop file?





Did I answer your question? Give your kudos and mark my post as a solution!

Proud to be a Super User!





Great questions. I refreshed it just before publishing it. Then, when the published version showed up with data missing, I refreshed that as well, to see if it would self-correct. But it didn't. 

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.