Forum Discussion

SEACHAD's avatar
SEACHAD
Icon for Helper I rankHelper I
6 years ago

Power BI cannot import Usage details data with Azure Cost Management Connector

Using the Azure Cost Management Connector with Power BI, using an Enrollment Number, I can import data of some tables (Balance summary, Budgets, Pricesheets, RI recommendations, RI usage summary, ..)...
Need Help
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , SEACHAD 

According to your description, I can't reproduce  the problem and determine the cause of the error.

Maybe you can take a try of disabling the function of “ Automatically detect column types and headers for unstructured sources” in options.

Beside ,I recommend the following posts for your reference:

https://community.powerbi.com/t5/Desktop/Power-BI-desktop-cannot-import-data-with-Azure-Cost-Management/m-p/824179

 

If the issue is still there, sorry for that we do not found an effective solution. We suggest you to open a ticket here for help if you are a pro user:

https://powerbi.microsoft.com/en-us/support/

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SEACHAD's avatar
SEACHAD
Icon for Helper I rankHelper I
6 years ago

Thanks for your fast answer 

 

I checked disabling the function of “ Automatically detect column types and headers for unstructured sources” in options. and I get the same result

 

 

 

But in Pricesheets as example

 

 

I'm pretty sure that I have the Enterprise Administrator role, but I will check it again before opening a ticket, as I said I can use the old conector without problems and also read de usage data on the azure web portal 

 

 

 

Thanks again

 

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi , SEACHAD 

    Can you show me the result in  the table RI Usage details after you click the "source" in "Applied Steps"?

     

    Best regards
    Community Support Team _ Eason

    • SEACHAD's avatar
      SEACHAD
      Icon for Helper I rankHelper I
      6 years ago

      Good morning,

       

      After several weeks having problems, this morning and without changing anything, in preparing this answer, I was able to obtain usage data.
      I only have problems even with RI usage details and RI usage summary

       

       

      Thanks again

       

      Luis

      • SEACHAD's avatar
        SEACHAD
        Icon for Helper I rankHelper I
        6 years ago

        I still have the same problems with the RI usage details and RI usage summary tables, it may be a permissions problem or I don't have any RI in my subscription.
        Is there any command in power query (M) to avoid this type of errors, something like the IFERROR of excel and in case of error that at least the rest of the tables are loaded?

         

        Thanks in advance