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

Thanks - fail to comprehend why PBI changes authentication specially in the service. Most confusing as we have 20+ Sharepoint files and folders all using the same authentication and the failure occured with different files/folders.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I believe this is because the credentails expire after certain time (my guess is 3 months). In your case, the credentials to the connection of your files might have been created at different point, suggesting the failure in connection of these at different times. Not sure how true this is though, it's just a guess