Forum Widgets
Latest Discussions
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.
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.
Standardization on the lowest sku for App Service Plan
Hi, Do you know if it's possible to standardize on the lowest SKU of an App Service Plan Premium V3 (P0v3) and then purchase reservations? Would these reservations be usable on P2v3 and P3v3, provided that the VM type is the same within all the SKUs?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
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
