cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheOllie
New Member

Last refresh failed: We cannot convert the value "[Binary]" to type Binary..

Last refresh failed: Sun Jan 06 2019 06:51:44 GMT 1100 (Australian Eastern Daylight Time) 

There was an error when processing the data in the dataset.

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

The exception was raised by the IDataReader interface.

Table: artifact. Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net

Activity ID: comeback

Request ID: 0cf83e31-0ca5-6529-525c-d986d08a7298

Time: 2019-01-05 19:51: Oz

 

The reports dataset is made from SharePoint folders holding Excel files (all with identically named sheets) differently named files, obviously. They are merged, this works fine. The dataset is then merged with data from the Azure Billing API, this works fine and if I refresh the data set within Power BI desktop, no issues.

 

In fact, I am spending a couple hours of my day each month just refreshing the report locally so that I can upload it over and over again to the APP which is shared throughout our entire organisation.

 

Read through all the posts, but no workaround seems viable. Anyone have some advise or whether this bug is being resolved?

2 REPLIES 2
nishantjaincent
Advocate IV
Advocate IV

The issue seems to be the privacy settings in Power BI Service. Try the solution here 

v-yulgu-msft
Microsoft
Microsoft

Hi @TheOllie,

 

Please try the suggestions mentioned in below links.

Underlying error message: We cannot convert the value "[Binary]" to type Binary

Expression.Error: Cannot convert the value "[Function]" to type Function

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors