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 Anonymous,
I test to get data from sharepoint online and follow your steps to publish to service, it works on my side.
Have you test on the last version of power bi ?
If you create a new report which original datasource, can you reproduce it?
In addition, I think the issue may related to custom function which used to convert your data in power query.(current custom function only available on desktop)
Regards,
Xiaoxin Sheng
I have the same problem, and I think it was due to the step of Combine Files for the files in the SharePoint. The report in Power BI Desktop works fine. We just can't refresh the dataset after the report is published. My workaround is to create a table with the Combine Files using Power Query, and use this table as a new data source. I now can refresh my new dataset after I publish the report.
Hi sukajalan2
Where are you creating this tabel / where is saved? In Power BI or do you create a local tabel and save it On SharePoint?
AnonymousI created the the table in Excel (Power Query) and saved it in SharePoint.
Well this is not a solution of the problem. This is "going around the problem"
The issue still exists.