Forum Discussion
Different data between Online and Desktop
Microsoft EmployeeHi ColinGeddes,
Normally, the report and dataset are same in Power BI desktop and service. It's weird to miss some records. " I've downloaded the online PBIX file from online and ran it locally, no changes made, and the data/visuals are different than online." mean you publish all reports and dataset successfully. If you set any Row-level security in your report? Or your admin set any access permisson in service? Could you please share the .pbix file for further analysis?
Best Regards,
Angelia
Hi Angelia,
Yes, the same pbix file is uploaded on the web service that is opened in the desktop version and the results are different. No row level security, no access permissions (I'm the admin), no other config or changes (beyond setting the API / Sharepoint login details required when moving pbix files).
I'm just not sure where else to look! It appears as there is a difference with the web API json processing between the service and desktop versions, with the service version is loosing some records as it processes. I've tried to find something obvious in the raw data (special characters, null values, etc), but nothing stands out. It's a really unlikely possibility, but that's where things are pointing.
The pbix has some semi-sensitive information that I'd rather not publish here, happy to share via a remote session or through other means.
- v-huizhn-msft
Hi ColinGeddes,
I guess the missing records are caused by the web API json processing, but I am not specific about API. So I can't give the detailed reason, I personally suggest you post your case to the Power BI developer community, where you will get delicated support. Thanks for understanding.
Best Regards,
Angelia