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
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
Thank you. I solved my issue by applying this method!
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.
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
Thanks, you really saved my day and lots of hours debugging 🙂
this also had happen to us when we upgraded to premium and there were SP excel Files both from old sp and sp online. your solution worked, thanks!
(just updated the data source settings/reloggined)Thanks for this tip. It really works, that was my problem !
This is the real solution and should be marked as such.
I will second it, that this above is the fix and should be marked as the answer.
This wooked for me
