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: 
kerry6a

Azure Cost Management App Expression Error

Submitted by on ‎03-31-2023 06:01 AM

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

See more ideas labeled with:
4 Comments (4 New)
Comments
kerry6a
Regular Visitor
‎03-31-2023 12:02 PM

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
Community Support
‎04-03-2023 01:20 AM
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
‎05-11-2023 06:56 AM

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
‎05-30-2023 05:58 AM

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

Idea Statuses