Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Refresh failing for reports using Azure Cost Management tables

 

 

For the past week now, all my reports that are using the Azure Cost Management data tables are failing with the error:

 

Data source error: Expression.Error: <pii>We cannot convert a value of type Binary to type Function.</pii>. ;We cannot convert a value of type Binary to type Function.. The exception was raised by the IDbCommand interface. Table: RI recommendations (single).
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: fd876af9-ceba-4a4c-b3d9-fa79bcdad1e9
Request ID: 603eb53f-9af9-448f-8998-a54602d4c0b0
Time: 2021-09-11 07:10:08Z

 

Is there a fix for this?

 

Status: Accepted
Comments
Steven_VM
Regular Visitor

Hey,

Same for us. The refresh succeeded this morning without any error.

Thus, something got resolved somewhere. 🙂

v-robertq-msft
Community Support
Status changed to: Accepted
 
ireneking
Regular Visitor

Same. Errors for 6 weeks.

 

Data source errorExpression.Error: We cannot convert the value <ccon>"Required Field: 'Enr..." to type List.. Value = Required Field: 'Enrollment Number' is required field.. </ccon>. The exception was raised by the IDbCommand interface