Missing data after refresh

[Anonymous]

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. 

[Anonymous · Accepted solution]

Problem solved. Turns out an account that was used to access the database and configure gateway didn't have full access to this database. So I changed it to my personal account and it worked. 

[Anonymous]

@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

[Anonymous]

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.

[amitchandak]

@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

[Anonymous]

Hi @amitchandak thanks! Credentials for all sources seem ok.