Forum Discussion
Partial data imported after Scheduled Refresh
Hi,
I have dataset that connects to multiple Folders (Country) on Sharepoint tolder. The files are of type .xlsx and can vary from 1MB to 60MB. The scheduled refresh (Power BI Service) works well and is successful every day. However I noticed that not all data is imported and it varies with each refresh. I monitor the data import via a report that basically counts the rows of records for a given day
Example: If 20,000 rows were imported for Country1 on 1st of Feb and 15000 rows were imported for Country 2 on 1st Feb, I would see a completely differnt figure on 2nd Feb. Any idea why this is happening and how to correct this
I have a premium workspace
Floyd
2 Replies
That is nearly impossible to troubleshoot here in the forums. Seems like some kind of intermittent data issue perhaps but really hard to tell. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".hi FMF
It seems a known issue, please refer to here:
https://powerbi.microsoft.com/en-us/support/
You may try to restart the capacity to see if it get better.
https://docs.microsoft.com/en-us/power-bi/service-admin-premium-restart
Regards,
Lin
