Application Insights - Power BI limit to 500k rows

[Anonymous]

Hello World!

I'm trying to connect Azure's AppInsights but PBI only takes 500k rows max.

Do you know any workaround this situation? or any alternative?

I need to cross some sql servers and that data, and also take advantage of PBI visualisation and Share-ability.

[diverdown1964]

You can work around this limitations wuith a function - Exceed the 500,000 row limit in Application Insights and Log Analytics with Power BI – The White Pag... 

[v-yulgu-msft]

Hi @Anonymous ,

It looks like a limitation to the data export of Application Insights API, you'd better contact the Azure Application Insights support team to consult this problem.

As a workaround, rather than directly connect to Application Insights via biult-in data connector, maybe you could export data from Application Insights into other supported DB or files by Power BI.

Best regards,

Yuliana Gu