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
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.
Yes, thanks for your quick answer !
but did you schedule the query refresh of the excel file or is it still a manual action ?
it is manual.
for automation, you can use macro to convert xlsb to xlsx (basically, open the xlsb file and save as xlsx).