Latest Enterprise DNA Initiatives

Refresh Fails: Data Source Error "[Binary]"

I have built a data model with the data in SharePoint. If I refresh in PBI desktop, it refreshes without a problem. However, when I try to refresh in the service I get the following error message…

Data source error: Expression.Error: We cannot convert the value “[Binary]” to type Binary… . The exception was raised by the IDbCommand interface. Table: GL Detail.
Cluster URI:
Activity ID: 9a075988-69b1-4d0e-abe6-593fcdf0bf3d
Request ID: 3ca5fa34-9413-417c-b561-c1db66aa720e
Time: 2022-08-05 02:43:29Z

When I was searching on the web, it mentioned something about privacy settings. I thought I have the privacy settings as Organizational with Microsoft login.

I found a solution to this problem.

It does appear to be a privacy settings issue.

Here is an article about privacy settings from Miguel Escobar.

In my case, I moved the queries to a dataflow, but that did not solve the issue.

Then in the dataflow I went to Options → Project Options

Then I clicked on the check box for Allow combining data from multiple sources.

I hope this is ok. All my data is internal. I’m not going out to the web to get outside data and bring it in.

I think the proper way to correct it is to reset all the privacy settings.

In any case, now my dataflow/dataset can refresh in the service.