Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Underlying error message: We cannot convert the value "[Binary]" to type Binary

  Hi, everyone,   I have a two data sources one by a gateway and a several Excel files (with the same structure) from SharePoint. All the excel files are coming in i Power BI as one tabel. The r...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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!!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

  • annemari's avatar
    annemari
    Frequent Visitor
    6 years ago

    More than a year later struggling with the same problem and riri-s suggested link helped with workaround, thanks!