Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@Alex_0201
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 @V-pazhen-msft 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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |