Forum Discussion
Missing data after refresh
Hi there. Why would certain data (always only from two columns) disappear in the reports after refreshing it in PowerBI service. After uploading pbix files from OneDrive (tried Teams as well) and configuring gateway, the data is there and the reports look like they should. Once I refresh it manually or via scheduled refresh the data is gone and it never reappears.
5 Replies
Anonymous ,
Once you upload open data connection setting in service make sure credentials are correct
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Hi amitchandak thanks! Credentials for all sources seem ok.
Anonymous
Where is your datasources? I see you have pbix in onedrive, does the data source file also there?. If the data sources is online for example onedrive, you do not need a gateway to refresh.
For the issue, I wonder what do you mean by data disappear, the data form datasource didn't refresh to the dataset on service or just the value is hidden in the report visual?Regards
Paul Zheng _ Community Support Team
Hi Anonymous it's an sql db. I suspect it could be due to a service account (not my personal account) used for setting up the gateway.
I say disappear because once the reporst are refreshed, this data is not displayed anymore. And if I downlad this altered pbix to the desktop and open it, this data is still missing in the report.
