Forum Discussion

chewcheelim's avatar
chewcheelim
Regular Visitor
7 years ago

Microsoft Azure Consumption Insights Content pack failed to refresh

For some reason, the Micorosft Azure Consumption Insights content pack failed to refreshed in our prd environment/workspace. 

 

Has this content pack obsoleted ?  If so, it has been replaced by this ? https://docs.microsoft.com/en-us/power-bi/desktop-connect-azure-consumption-insights

 

Detail error message :

Data source error: The 'Consumed Quantity' column does not exist in the rowset. Table: Usage Details.

 

Any advices much appreciated. 

thanks!

Need Help

5 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi chewcheelim ,

     

    By my test, the Microsoft Azure Consumption Insights content pack still exists.

    According to your detail error, you can download the pbix file from the report page in Power BI Service. Open it in Power BI Desktop to check which visual is broken in Visual pane or which column is created with incorrected syntax in Fields pane. Then you can determine if add to the visuals or not.

    You can also refer to this case which is similar to yours: https://community.powerbi.com/t5/Service/The-HasUniqueRoleAssignments-column-does-not-exist-in-the-rowset/td-p/174257

    Here is the troubleshooting link: https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios

     

    • chewcheelim's avatar
      chewcheelim
      Regular Visitor
      7 years ago

      Thanks for your reply. I tried to follow steps suggested, for some reason from my end. I am not able to download the PBIX file from my end. The selection is grayed out. (see attached pic) . 

       

      I think removing the unwanted column makes sense, if I can download the PBIX file. 

      Again, appreciate your reply. 

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-eachen-msft, Do you know why I am not able to download the pbix ?

      • v-eachen-msft's avatar
        v-eachen-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

         

        From this article, you can see there is a limitation: 

         

        • The report must have been created using Power BI Desktop and been published to the Power BI service, or the .pbix must have been uploaded to the service.

        Olease check if these reports created on Power BI service directly. If it is, it's not be able to download pbix file.