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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Azure Cost Management App Expression Error

Data source error: Expression. Error: The column '<ccon>amount' of the table wasn't found. amount. </ccon>.

The exception was raised by the IDbCommand interface. Table: RI charges.
Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID: e743bb34-91a7-4edc-85bb-ae1451687387
Request ID: 6f9337d1-24b6-9818-98e8-f6d5ee8a1431
Time: 2023-03-31 12:45:56Z

Status: Investigating

Hi @kerry6a ,

Does the error only occur in Service or both in Desktop? The error always happen when we have changed a column name in Power Query, but we still use the original column name in the following steps. Please check the column name "<ccon>amount" exists in the table and if any error returned in Power Query.

 

Best regards,

Community Support Team_yanjiang

Comments
kerry6a
Regular Visitor

The below now shows from same app.

 

Data source error: The 'Unit' column does not exist in the rowset. Table: Pricesheets.
Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 0b108c17-b1c1-3edf-a5fc-97c4f32456e9
Request ID: 4449f093-fdf9-34c3-2945-1ca6a19e241a
Time: 2023-03-31 18:46:30Z

v-yanjiang-msft
Community Support
Status changed to: Investigating

Hi @kerry6a ,

Does the error only occur in Service or both in Desktop? The error always happen when we have changed a column name in Power Query, but we still use the original column name in the following steps. Please check the column name "<ccon>amount" exists in the table and if any error returned in Power Query.

 

Best regards,

Community Support Team_yanjiang

ireneking
Regular Visitor

Same Issue - looks like the Azure Cost app was modified by Microsoft. The Azure Cost Mgnt app is not assessable via desktop. Its created by MS for corps to review spend. Hence any changes would be from Microsoft directly (all data cloud - linked from EA agreement). 

 

Was this resolved? 

ireneking
Regular Visitor

Was this resolved? This has been an issue for months.

 

Data source error: DataSource.Error: <ccon>Web.Contents failed to get contents from 'https://management.azure.com/providers/Microsoft.Billing/billingAccounts/XXXXXXXXX/providers/Microso...'' (400): Bad Request. DataSourceKind =

 

AzureCostManagement. DataSourcePath = Enrollment Number;XXXXXXXXXX. Url = https://management.azure.com/providers/Microsoft.Billing/billingAccounts/XXXXXXXX/providers/Microsof...'. </ccon>. The exception was raised by the IDbCommand interface. Table: Usage details.

Time: 2023-05-30 04:18:21Z