Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

IO Error '6' when schedule refresh

Hello Everyone,    Good Day! I keep on getting IO error '6' while schedule a refresh in report server.  I can refresh using Power BI desktop without any issue. But when it comes to report server...
Error Handling
d_gosbell's avatar
d_gosbell
Super User
5 years ago
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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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?