Forum Discussion
IO Error '6' when schedule refresh
Hi Gosbell,
Thanks for your answer.
Referring to statement: "Is there some process that is re-creating the file in question", are you referring to the query of the Power BI? I did have multiple query for same data source. I am not sure this might be one of the root cause?
The credential that I entered have permission to enter the data source location, and the report server also able to successfully refresh the data but intermittently. However, not all Power BI report is having the same issue. Some report do not face the IO error at all.
Anonymous wrote:
Referring to statement: "Is there some process that is re-creating the file in question", are you referring to the query of the Power BI?
No, I was wondering if this was a static file or if it was periodically exported from some other system. Or if someone manually updates it occasionally. If this file was generated by some other IT system and it periodically deletes and re-creates this file that could maybe account for this sort of intermittent error.
I don't think multiple Power BI files would be an issue as they should only request read access when opening the file.
Hi Gosbell,
Yes you are right, i set a schedular job to extract data into the folder overwriting existing excel source file. However, both schedular job and power BI scheduler refresh do not happen at the same time. Will that be the root cause?
Anyway to resolve?