I have set a scheduled refresh on Power BI but today found an error below but when I refreshed on Power BI desktop is no error.
Data source error: Expression.Error: <pii>We cannot convert the value "[Binary]" to type Binary.</pii>. . The exception was raised by the IDbCommand interface. Table: OB. Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net Activity ID: f33510b4-c75a-43bc-baed-951122f429bf Request ID: 10946e18-3a69-dd29-a8dd-494ab0e03ca0 Time: 2021-11-23 01:42:04Z
you might have connected a data source where a Column1 might be detected as a non binary so you would have manually changed it to Binary in the Query editor for your requirement. Later you might have replaced the data where the value in the Column1 might be the Binary and the power bi end also it might be automatically detected as Binary.
So this time it will throw this error as you have the Power query step to manually convert it to Binary again.