Power BI无法从Application Insights API获取所有数据
在Power BI中针对Application Insights API使用查询时，我无法检索所有数据.在Azure门户/日志分析中查询时，我从Power BI获得了不同的结果.
I'm having trouble retreiving all data when using a query in Power BI against Application Insights API. When querying in the Azure Portal / Log Analytics I get different results from Power BI.
没有进行采样，因此消息是完整的.查询看起来像这样
There is no sampling done, so the messages are intact. The query looks like this
Web.Contents("https://api.applicationinsights.io/v1/apps/<app-id>/query"，...)
我希望获得大约200万条查询 traces 的消息，但我只能得到3万条消息.最令人困惑的是，我进行的过滤越少，收到的数据就越少.
I'm expecting to get about 2 million messages querying traces, but I only get about 30k. The most confusing thing is that the less specific filtering I have, the less data I receive.
所以我的问题是，API可以导出多少数据有任何限制，我可以更改限制吗?任何帮助都会很棒！
So my question is, are there any limitations on how much data the API can export, can I change the limit? Any help would be great!
有3种方法限制发送的数据量:
There are 3 ways that the volume of data you send is limited:
- 采样(您已经提到过)
- 每日上限(如果您创建了默认上限，则默认为每天100 GB门户中的Application Insights资源，但如果在Visual Studio中创建Application Insights资源，则每天只有32.3 MB)
- 限制(将数据速率限制为每秒32,000个事件)
- Sampling (which you mention you've already looked at)
- Daily cap (which defaults to 100 GB/day if you create your Application Insights resource in the portal but only 32.3 MB/day if you create your Application Insights resource in Visual Studio)
- Throttling (which limits the data rate to 32,000 events per second)
我将在此文档中查看有关数据量的更多信息:
I would take a look at this document for more information about data volume:
https://docs.microsoft.com/en -us/azure/application-insights/app-insights-pricing#data-rate