Azure Consumption Insights tables are empty

[rixmcx59]

Hello all, I was hoping someone could tell me why Pricesheets, MarketPlace and Summaries table are empty? I am connecting to UsageDetails successfully in Power BI but it's my understanding that the other tables are needed to do more complex reporting.

Does Azure need to be confiured to collect data in these tables? Our org is new to using Azure as a data source and I can't find answers to questions I have.

rix

[v-yulgu-msft]

Hi @rixmcx59 ,

From this document, the Summary and PriceSheet tables are only available for the enrollment-level API Key. And please change te numberOfMonth parameter in Power Query for a test. 

Regards,

Yuliana Gu

[rixmcx59]

Hello, I can connect with an enrollment number and API key. My question is how are those tables populated in Azure? when I preview the tables there is no data.