a couple months ago and this week i got a strange bug on Power BI service with the data refresh. We cannot convert the value "[Binary]" to type Binary. Table: Query1 it took me a long time to see what was going on. this error only occur on power bi service. on power bi Desktop everything works fine. i end up with delete step by step in power query to reproduce the error. this way i found out that when i delete the merge from the table the refresh works fine. there was something strange with the merge function in power query. i reproduce it in a separate file, quick and dirty style, to test it and there the merge works fine. step 2 was to complete rebuild the table exactly like the original and it got the same error. what is going on: i used a 3 merge layer. table 1 is merged with table 2. and then i merge table 2 with table 3 (query1). and this cause the error. when i remove the first merge (table 1 to table 2) the refresh in power bi service works again. i have no idea what to do about it other than works around it. but i am happy to know what the limit are. source: query1 - sharepoint folder (excels) table 1 and 2 - Sharepoint lists.