cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Schedule data refresh failure

Hi,

 

I have set a scheduled refresh on Power BI but today found an error below but when I refreshed on Power BI desktop is no error.

 

Data source error: Expression.Error: <pii>We cannot convert the value "[Binary]" to type Binary.</pii>. . The exception was raised by the IDbCommand interface. Table: OB.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: f33510b4-c75a-43bc-baed-951122f429bf
Request ID: 10946e18-3a69-dd29-a8dd-494ab0e03ca0
Time: 2021-11-23 01:42:04Z

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

The information you provided is too little for us to judge. Please add more information.

First, I suggest you check whether there is a binary data type in column in Power Query.

Second, you can check whether there is a problem with data source credentials, privacy level(public) in service.

Or you can try to delete all reports related and re-publish it to see if it has issue.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,
Community Support Team _ Janey

View solution in original post

3 REPLIES 3
Aburar_123
Super User
Super User

Hi,

 

Below might be the issue,

 

you might have connected a data source where a Column1 might be detected as a non binary so you would have manually changed it to Binary in the Query editor for your requirement. Later you might have replaced the data where the value in the Column1 might be the Binary and the power bi end also it might be automatically detected as Binary.

 

So this time it will throw this error as you have the Power query step to manually convert it to Binary again.

v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

The information you provided is too little for us to judge. Please add more information.

First, I suggest you check whether there is a binary data type in column in Power Query.

Second, you can check whether there is a problem with data source credentials, privacy level(public) in service.

Or you can try to delete all reports related and re-publish it to see if it has issue.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,
Community Support Team _ Janey

Anonymous
Not applicable

Thank you for consideration.

 

I try to revise the query again and that solved the problem.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors