Forum Widgets
Latest Discussions
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 #AzureRetailPricing
Error on deployment on a CHE
I'm experiencing an error during the deployment of any package to a cloud-hosted environment. The error occurs specifically at step 11, 'Global Update script for service model: AOS Service,' and results in a failure to resume the deployment process. The issue happens on the DB sync, however if I tried to sync the DB from the visual studio it succeeded without any errors. And If I tried to restore another empty DB for example, the deployment will succeed. And if I tried to restore the DB on another CHE, the same issue happens. The issue is that we need this DB, because it is the Master configuration DB, so we cannot delete it. So my question is what is the best way to solve this issue and how can we know what is the issue with this DB? Thanks in advance.
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?
Selecting Tables to Sync from finance and operations | programmatically
Dears, I've some important questions please Is there any option to programmatically select Tables to Sync from finance and operations, currently it’s a manual process and time-consuming task? We’re open to any tool: PowerShell, Python, Power Automate & etc Is there any option to force the sync to start without waiting the interval settings in the advanced configuration? Choose finance and operations data in Azure Synapse Link for Dataverse - Power Apps | Microsoft Learn
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"
How we get Actual saving number once into Cost management portal of Azure for VM reservation
We have done multiple reservations for VM,SQL pass services but unable to find any kind of details for actual realise Saving numbers at anywhere in the Azure Cost management portal same is for saving plan commitment as well how to find actual-realise saving when we do commitment of saving plan for 3 years. also we do not have saving plan coverage or utilisation report at Azure cost management portal. all above features are available at GCP and Azure
