Forum Widgets
Latest Discussions
MCA Pricing
Hi, I am trying to get organization pricing for MCA customer using an api. Is there any api available for getting the organization discount pricing. For EA account, i found this api is available for fetching the pricing . https://management.azure.com/subscriptions/%7bsubscriptionId%7d/providers/Microsoft.Billing/EA/agreements?api-version=2020-05-01 Like this is any api avilable for getting MCA account organization discount pricing.
Setup of FinOps Toolkit
OK, so I've deployed the toolkit, setup the exports on an MCA account with 9x billing profiles, created FOCUS + Price Sheet exports for each billing profile followed by reservation details, transactions and recommendations for each billing profile. Where it's failing for me is that I try to run the msexports_ExecuteETL and msexports_ETL_ingestion and it prompting me for msexports_ETL_ingestion: blobPath destinationFile destinationFolder ingestionId schemaFile exportDatasetType exportDatasetVersion msexports_ExecuteETL: folderPath fileName What should these value be? Also we are currently migrating from EA agreement, to MCA, on the Cost Management Exports I can't see the subscription residing in the MCA agreement and therefore can't select the storage account in there to export to, why might that be?
finops toolkit - missing clusterUri
I installed finops toolkit but I did not get any value in the clusterURI from my hub. Any thoughts on how to fix it? thanks instructions: Copy the Data Explorer cluster URI: Select the resource group where your FinOps hub instance was deployed. Select Settings > Deployments > hub > Outputs. Copy the clusterUri output value.
Understanding Cloud Cost Fluctuations with Power BI
Staying on top of your cloud costs requires regular reviews. There are many ways to slice and dice your cloud costs; one approach I find helpful is comparing daily and monthly cost deltas. Below is a visual from my Power BI report showing how my previous month’s costs compare to the month prior. The visual is filtered to only show delta increases/decreases over $1K. I can quickly see we spent $5K more on Azure SQL Database in the selected month compared to the previous month. I call this my 'large cost swings' graph. I understand that everything is not linear, nor do things translate nicely from one day or month to the next. However, the data has a story to tell. What I ask my team to focus on is the story the data is telling. In this case, we made some modifications to ADF and SQL, leading to a $4K net reduction in costs. Some stories explain the outcome of one or more actions. Then there are those stories which can help shape your future consumption and spending.Navigating Azure Retail Pricing Data in Power BI: My Journey
Recently, I embarked on integrating Azure Retail Pricing data into my Power BI Cost Management dashboard. Initially, this seemed daunting, but with the right orientation and assistance from Copilot, I successfully navigated through it. Did you know? Microsoft offers a Retail Pricing API that allows you to import data into Power BI in your preferred currency. The first hurdle I encountered was the API’s paginated results. To overcome this, I created a function in Power BI that iterates through the paginated results using a base URL. To my surprise, both the Retail Price table and the Azure Cost Management table had only one common column: meterID. This led to a many-to-many relationship, which is less than ideal as it introduces data ambiguity. Since there were multiple matching meterIDs with different retail prices, I addressed this by creating Measures. Additionally, I created another measure to calculate the retail cost, as the Retail Price table did not contain any consumption data. Happy to share more details if anyone's interested. #Azure #PowerBi #AzureCostManagement #AzureRetailPricingStep by Step to Create a Tag Filter in FinOps Hub (Portuguese)
Now live on the Azure InfraGurus regional blog, is guidance on filtering by tags using FinOps hubs. This local language blog is published in Portuguese. https://techcommunity.microsoft.com/t5/azure-infragurus/passo-a-passo-para-criar-um-filtro-de-tag-no-finops-hub/ba-p/4249215 If you'e looking for more Infrastructure guidance in Portuguese, check out the rest of the blog: https://techcommunity.microsoft.com/t5/azure-infragurus/bg-p/AzureInfraGurus
Cost Optimization to help Finance Team
Dear All, I would need all the possibilities in Azure to optimize the cost which will help the finance and IT team with the budget. How can we control the cost while using Azure resources like virtual machines, virtual networks, load balancers, app gateway, storage, and other developer team tasks which is spinning the cost like water. Need the steps to manage the cost and is there any alternative way to use the Azure resources with cost effective?while running azure cost management API from Azure Devops pipeline its fail
Hi, I struggle in running one PowerShell script in Azure Pipeline. The PowerShell works fine under windows 11. but when I run the same script in the azure pipeline with "Windows-latest" its fails with stating error "the remote server returned an error: (400) Bad Request". script contets: --------------------------- $currentDate = get-date -Format "yyyy-MM-dd" $startDateOfLastMonth = (get-date $currentDate -Day 1).AddMonths(-1) $endDateOfLastMonth=GET-DATE $startDateOfLastMonth.AddMonths(1).AddSeconds(-1) $billingPeriod = (get-date).AddMonths(-1).ToString('yyyyMM') #get-date -format 'yyyyMM' function get-token(){ $token = (Get-AzAccessToken -ResourceUrl 'https://management.azure.com' ).Token $headers = New-Object "System.Collections.Generic.Dictionary[[String],[String]]" $headers.Add("Authorization","Bearer $token") return $headers } $headers = get-token $subscriptions = Get-AzSubscription $usageUri = "https://management.azure.com/subscriptions/$($subId)/providers/Microsoft.Billing/billingPeriods/$($billingPeriod)/providers/Microsoft.Consumption/usageDetails?api-version=2018-03-31&$filter=properties/usageStart ge $startDateOfLastMonth AND properties/usageEnd le $endDateOfLastMonth" Invoke-RestMethod $usageUri -Headers $headers -ContentType "application/json" -Verbose --------------------------------------- The above code failed on the last command when trying to run "Invoke-RestMethod"Azure compute reservation exchanges will remain available until further notice
The availability of Azure compute reservation exchanges for Azure Virtual Machine, Azure Dedicated Host and Azure App Service has been extended until further notice. Originally with a deadline of 1 July 2024, we have extended this and customers may continue exchanging their compute reservations for different instance series and regions until we notify them again, which will be at least 6 months in advance of the new deadline. Learn more: https://learn.microsoft.com/azure/cost-management-billing/reservations/reservation-exchange-policy-changes?WT.mc_id=modinfra-0000-socuff
