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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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