User Profile
CookieMonster
Helper I
Joined 8 years ago
User Widgets
Contributions
Re: Azure Cost Management connector causing error 'We cannot convert the value null to type Record.'
Yes I replaced {billingAccountId} with my acutal {billingAccountId}. Yes it only occurs, occasionally, sometimes it will refresh fine and all data is available as expected, at other times the refresh fails and I get this error.Azure Cost Management connector causing error 'We cannot convert the value null to type Record.'
Ref: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management Azure Cost Management connector causing intermittent error 'We cannot convert the value null to type Record.' I have this issue intermittently both on Power BI Web and Desktop. I reproducted on Desktop today by: Create new Power BI file Get Data > Azure Cost Management Scope: Manually Input Scope Scope Identifier: /providers/Microsoft.Billing/billingAccounts/{billingAccountId} Number of Months: 6 I then got the error: So at this point, I have not touched the data tables at all, or done any visuals etc. Any idea what I can do to resolve this intermittent issue or who I should contact?Re: Stacked Area Chart with Cumulative Cost - Straight line when no values
I have just tried this and it has left me with this: So it no longer looks to be cumculative, any ideas where I went wrong? My measure is now: CumulativeCost = CALCULATE ( SUM ( 'Usage details'[costInBillingCurrency] ), FILTER ( ALL ( 'Date'[Date].[Date] ), 'Date'[Date].[Date] <= MAX ( 'Date'[Date] ) ) )Stacked Area Chart with Cumulative Cost - Straight line when no values
Hi, I have the following Stacked Area Chart What I am trying to work out, is how I can make it do a straight line across, when no further data exists for that legend item, or if data is missing for that legend item on a particular date. This is the measure I currently have to work out the cumulative cost: CumulativeCost = CALCULATE ( SUM ( 'Usage details'[costInBillingCurrency] ), FILTER ( ALL ( 'Usage details'[date] ), 'Usage details'[date] <= MAX ( 'Usage details'[date] ) ) ) I hope my question makes sense and someone can help.
