Forum Discussion
Server dails to refresh "Qe cannot convert the value "[Binary]" to type Binary" No binary value
I am getting to types of errors which are probably related. For context, the dashboard is a large and complex model with over 20 queries and 15 data sources, pulling from Azure, Shaerpoint and other sources.
First, on the desktop, I can only refresh the data when I open the Power Query editor, refresh the data sources and then close it. Then I can refesh the data with no problems. Otherwise, one of the query dependencies will fail.
Second, once I do the Power Query editor part and I upload, I always get this error but in different queries: Data source error: Expression.Error: We cannot convert the value "[Binary]" to type Binary.. . The exception was raised by the IDbCommand interface. Table: XXXXX.
The Table will change on each iteration. None of the tables have binary values.
Anonymous for binary to type binary issue:
You need to make sure that all your connections where you are appending or merging data have the same privacy level.
Check this link: https://community.fabric.microsoft.com/t5/Service/Underlying-error-message-We-cannot-convert-the-value-quot-Binary/m-p/210034
This might also solve the first error?
Cheers,
Nemanja Andic
2 Replies
Anonymous for binary to type binary issue:
You need to make sure that all your connections where you are appending or merging data have the same privacy level.
Check this link: https://community.fabric.microsoft.com/t5/Service/Underlying-error-message-We-cannot-convert-the-value-quot-Binary/m-p/210034
This might also solve the first error?
Cheers,
Nemanja Andic