Forum Discussion
Underlying error message: We cannot convert the value "[Binary]" to type Binary
AnonymousI created the the table in Excel (Power Query) and saved it in SharePoint.
For anyone who is still having this issue, I found the reason for the error to be the "Privacy level" setting in Power BI service. You need to make sure that all your connections where you are appending or merging data have the same privacy level.
This also explain why it would work in Power BI Desktop and not in Power BI Service as they can have different settings.
Every time I have this error, I check the privacy level of all the credentails and I find that in one of the setting have either changed or not set to begin with
Hope this helps others
Nishant
I have the exact same problem too!
I load excel files from 2 different SharePoint folders. I then do reference this to a new query, which is not a solution to me apparently... I combined the binaries using the Excel.Workbook() formula to get the Excel files' contents. It works great in PBI Desktop but not by schedule refresh in the service. Annoying!!
I have the same problem, there issue is not actually resolved. :(
Update: i came across this issue, that is almost the same as mine. --- https://community.powerbi.com/t5/Desktop/Formula-Firewall-Query-references-other-queries-so-it-may-not/td-p/18619
and there, Mat provided a link to this blog with a solution that actually worked!
Ken Puls article -- https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
i hope this will help you too.
More than a year later struggling with the same problem and riri-s suggested link helped with workaround, thanks!
