Solved: Scheduled Refresh failure

ritanoori · ‎05-18-2019

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 · ‎05-19-2019

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,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.