Forum Discussion
Data not complete after refresh
Hi
It seems we have similar issues. I have posted mine in this thread http://community.powerbi.com/t5/Service/Scheduled-Refresh-During-SSAS-Refresh/m-p/25074#U25074
I'd rather think the issue in my case is due to PowerBI schedule refresh reading data from the SSAS cube at the moment when some of cube's partitions are being processed. Can this be the reason in your case?
Tsanka yes, the result in both our cases seem to be the same. However, I load multiple tables from our postgreSQL database and only experience these issues on one of the tables, not on all of them. I could think of two possible causes for that:
1. This table gets updated as the last one in my dataset and hits the 1M rows/hour limit and the update is stopped. In this case it would be good if we could get a notification that the limit has been reached.
2. The processing/calculation of my data and the calculated columns causes the refresh to stop after a certain time. In this case an error message should be given.
I suppose that if it is the 1M row limitation, than you should not be able to make 2 on-demand refreshes of your dataset run one immediately after the other.
May be this can eliminate one of the possible causes.