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
Hello,
I have exactly the same issue.
I didn't find the way to get through this issue.
I have 2 type of Data source : Excel File on 365 and Sharepoint Folder.
I have 2 Sources "Sharepoint Folder" to have 2 different tables and I Combine these 2 tables at the end.
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.
Hi sukajalan2
I am digging up this subject because I have the same issue and your solution interests me a lot but I don't know how to load an excel power query report on my power bi service
could you help & explain ?
thx !
Anonymous I save the .xlsx file in SharePoint and use it as the data source for Power BI report. I hope this helps.