Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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.

cgreenholt

Refresh failing for reports using Azure Cost Management tables

Submitted by Advocate I on ‎09-13-2021 06:11 AM

 

 

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
See more ideas labeled with:
23 Comments (23 New)
Comments
marcelswinkels
New Member
‎09-13-2021 11:57 PM

We are having similar issues with our Azure Cost Management reports:

 

Processing error: We cannot convert a value of type Binary to type Function.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 30d2e02f-67ee-493c-bec7-d8f4c075f29e
Request ID: c261c658-f8da-a73e-5c93-fc1ec2743267
Time: 2021-09-14 05:31:32Z

v-robertq-msft
Community Support
Community Support
‎09-14-2021 12:37 AM

Hi,

A similar issue has been reported internally, so stay tuned. ICM: 260595655

 

I will update here if I got any latest information about this case.

 

Best Regards,

Community Support Team _Robert Qin

Anonymous
Not applicable
‎09-14-2021 04:27 AM

Getting below error when trying to use Manual/Scheduled refresh for data source for any Power BI dashboard/report which points to AzureCostManagement connector. 

 

Scheduled refresh failure was on 10 Sept 2021, 09:27 AM

 

Today I did manual refresh, got below errors.

 

First error:

 

ktaylor_2-1631618485069.png

 

Second error:

 

ktaylor_1-1631618388695.png

 

kerry6a
Regular Visitor
‎09-14-2021 07:15 AM

I am also experiencing the same issues.

Anonymous
Not applicable
‎09-14-2021 11:25 AM

I have the same issue with the powerbi Reports.

ANA_JAK
Regular Visitor
‎09-15-2021 07:25 AM

The same issue here (failing to update since 12/09/2021):

Processing error: We cannot convert a value of type Binary to type Function.
Cluster URI: WABI-NORTH-EUROPE-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 038a5b06-dbdb-4a29-8eab-f3c0b17e5ffb
Request ID: 1a051465-2704-93ad-4eb0-b0b52e30e771
Time: 2021-09-15 13:24:30Z

CharlieF
Regular Visitor
‎09-15-2021 09:56 AM

Same here. @v-robertq-msft will there be any updates in this channel?

dwarnerbn
Regular Visitor
‎09-15-2021 07:17 PM

Ditto

SEACHAD
Helper I
Helper I
‎09-16-2021 03:15 AM

Any news about this issue?

We have been with it for almost a week and there is no response from microsoft (at least that I know of)

 

 

ncbshiva
Advocate V
Advocate V
‎09-16-2021 04:18 AM

I am also facing the same issue.

Idea Statuses