Azure Cost Management Connector - RI Recommendations

[lkshck]

Hey,

I'm using the Azure Cost management connector and imported the tables "RI recommendations (shared)" and "RI recommendations (single)" which are described here:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management

According to the description to those tables I should get the recommendations for my subscriptions, but in the there is no relation to a subscription. How should I know in which subscription this reservation should be booked? Does anyone know if this is by design or do you faced the same issue?

Best regards

[sakBI]

Thanks! it worked  perfectly

[v-zhangti]

Hi, @lkshck 

For the account from which you want to know the reservation was booked, try exporting RI usage details and Usage details to see.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lkshck]

Hey @v-zhangti ,

I already have the details about the booked reservations. What I want to have is the recommendations. Those should be available via the tables "RI recommendations (single)" and "RI recommendations (shared)". But in both tables there isn't any relation to a subscription so I don't know in which subscription I should book them.

Best regards

[sakBI]

Hi,

Did you manage to solve that ? I'm facing the same issue and don't find any related documentation.

Regards,

[lkshck]

I just solved it with using the the Consumption API via Web connector instead of the RI recommendation tables from the Cost Management connector. This works fine from my point of view, as you can use OAuth2 authorization in the same way like the Cost Management connector.

API:

https://management.azure.com/providers/Microsoft.Billing/billingAccounts/{{enrollmentNumber}}/providers/Microsoft.Consumption/reservationRecommendations?api-version=2021-10-01