Scheduled Refresh failure

[ritanoori]

Hello
I have my pbix file which is connected to Sharepoint folders and excel templates. the local refresh on my laptop is working perfectly, however the scheduled refresh is failing because of below error

has failed to refresh.
Failure details:

We cannot convert the value "[Binary]" to type Binary.. The exception was raised by the IDataReader interface. Table: Revenue Data

can you please advise?

Thank you

[v-cherch-msft · Accepted solution]

Hi @ritanoori 

Please try the suggestions mentioned in below links.If it is not your case,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".

https://community.powerbi.com/t5/Service/We-cannot-convert-the-value-quot-Binary-quot-to-type-Binary...

https://community.powerbi.com/t5/Service/Underlying-error-message-We-cannot-convert-the-value-quot-B...

Regards,