Empty tables when connecting to Azure Cost Management

[Anonymous]

I'm trying to connect to a customer's Azure billing data with the Cost Management connector.

So far I have succesfully connected and viewed the following tables:

The problem is only the two marked (RI Recommendations) are showing any data, whilst the rest is empty:

Is it a permissions' issue or am I doing something wrong in Power BI ?

The permissions I have so far are:

I have a standard RBAC reader role with AO view charges enabled.
I have also had my account added to the customer's Enterprise Administration portal.
I have the "Read Only Enterprise Administrator" or a "Partner" role (both have same permissions).

This is the documentation I follow:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management

[v-kelly-msft]

Hi  @Anonymous ,

Check whether it's about the limitation below:

Limitations and considerations

You might receive a 400 bad request from the RI usage details when you try to refresh the data if you've chosen date parameter greater than three months. To mitigate the error, take the following steps:

1. In Power BI Desktop, select Home > Transform data.

2. In Power Query Editor, select the RI usage details dataset and select Advanced Editor.

3. Update the Power Query code as shown in the following paragraph(s), which will split the calls into three-month chunks. Make sure you note and retain your enrollment number, or billing account/billing profile ID.

   For EA use the following code update:

For the related reference,pls see below：

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-azure-cost-management

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @v-kelly-msft ,

I don't receive the "400 bad request". The tables are empty, like there were never any charges registered.  Just no data. Power BI:

But I can see that this is not the case, when I go to Azure Portal:

[makthemax]

Did you get a solution @ anonymous and @v-kelly-msft , I am getting different errors in different tables. For RI usage I get RI Usage Details Failed - Couldnot retrieve web.contents. For usage details and usage details amortized, I am getting 400 bad request even though the 3months period is not violated(its under 2 months) ,authentication error for others.