Published Report vs. Desktop Report: missing data?

[chicagolarsons]

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:

From SharePoint:

[chicagolarsons · Accepted solution]

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]

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

[chicagolarsons]

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.