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

Thanks, you really saved my day and lots of hours debugging 🙂