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
My solution was to create a Power Query report combining the files, upload to Power BI Service, schedule the refresh, and use it as the data source for Power BI report.
Hello!
Thanks for your answer.
When you speak about Power Query report, it's on Excel?
Yes, it is using Excel.
Hello!
I find the issue : For the final generate table in a "Sharepoint Folder" source, you can't merge with another table!!! I don't know why.
I needed to merge with a DATE table.
So I did a reference from the table genrate by the "Sharepoint Folder" source, did the merge in the new table and it works!
Mystery!!