cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandraf Frequent Visitor
Frequent Visitor

We cannot convert the value "[Binary]" to type Binary. Table: Data

I have created a PowerBI Desktop Model with my data source being a Sharepoint Folder.

 

I have been able to import and combine my files within the folder and refresh the model successful via the desktop.

 

I have now published to powerbi.com and I'm getting the below error when I try and refresh

 

We cannot convert the value "[Binary]" to type Binary. Table: Data

 

Any ideas?

6 REPLIES 6
sandraf Frequent Visitor
Frequent Visitor

power bi expression error we cannot convert a value of type binary to type list

I have created a PowerBI Desktop Model with a connection to a Sharepoint Folder.   I have been able to input the files within folder without and issue and refresh my model.

 

However I have no published to PowerBI.com and the refresh wont work.  I get the following error.

 

We cannot convert the value "[Binary]" to type Binary. Table: Data

 

Can anyone help?

 

Thanks

Sandra

Highlighted
Super User
Super User

Re: We cannot convert the value "[Binary]" to type Binary. Table: Data

I had a similar problem.  I ended up cheating and just converting it to TEXT, then making use of MID to check individual binary digits.  Worked fine as long as you don't need to do any binary math.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


v-ljerr-msft Super Contributor
Super Contributor

Re: power bi expression error we cannot convert a value of type binary to type list

Hi @sandraf,

 

Have you tried the solution provided by @Ross73312 above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. Smiley Happy

 

Regards

sandraf Frequent Visitor
Frequent Visitor

Re: We cannot convert the value "[Binary]" to type Binary. Table: Data

What did you convert to text? The Binary that its referring to content of the sharepoint folder and files in it.

 

If you convert that you can't then invoke the Binary function to read the files.

Super User
Super User

Re: We cannot convert the value "[Binary]" to type Binary. Table: Data

We might be talking about 2 different types of data.  I was referring to a data set where information was stored in binary.  This was data flags held in Active Directory, where each binary digit referred to a True/False of a given property of the record.

 

I believe you are talking about binary in terms of a File or Picture.  This won't be what I have described.

EDIT:  Made an opps.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


hftrc001 Frequent Visitor
Frequent Visitor

Re: We cannot convert the value "[Binary]" to type Binary. Table: Data

I'm having a similar issue, so I'm wondering if this has been resolved...

 

On the Desktop, I link to a SharePoint folder that has multiple excel and csv files in it.  In the sharepoint site they are grouping in multiple folders, so it no big deal but using the method to bring them into Power BI, I have to perform some filtering steps to get the files I need to combine.  As stated prior, once I hit the Combine Files on the Desktop version it works perfectly, everything comes in and I have no issues refreshing my data.  However, once I publish to the web and try to refresh from there, so that subscribers to my report get automatically notified, I'm getting the same error message...

 

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: We cannot convert the value "[Binary]" to type Binary.. The exception was raised by the IDbCommand interface. Table: Finance - JE Review.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: a4fdefa8-6220-48db-9c4f-adae6868a6fd
Request ID: 94d93a50-6921-59dc-227a-eded038ea081
Time: 2018-11-07 12:46:42Z