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
  • sukajalan2's avatar
    sukajalan2
    9 years ago

    AnonymousI created the the table in Excel (Power Query) and saved it in SharePoint.

  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you! You are amazing! I had the same issue in Power BI online only; it worked in Power BI desktop. I even tried to use the exact same queries in a dataflow online and received the same errors. So simple! Microsoft should really consider making this error more apparent in the error text.

 

I'm adding the different errors I received to this post so this post will hopefully come to the top when those errors are searched in Bing/Google.

  • Expression.Error: We cannot convert the value "[Binary]" to type Binary
  • Expression.Error: We cannot convert the value "[Record]" to type List