Exporting data from application insights to Power BI limitaion to 50k rows per table

[rpatil]

Hi,

I am trying to export data from application insights to PowerBI. But i think there is a limitaion of 50k rows limit from application insights to powerbi. I have searched on internet people have limitaion of 500k rows, is there a setting option for this.

What is the best practise of exporting data from applciation insights to power bi

Thank you

[v-henryk-mstf · Accepted solution]

Hi @rpatil ,

What data are you specifically referring to export, Application Insights this function has been replaced in the early days.

"Service content packs are being replaced by Template apps. As of September 25, 2019, a number of content packs have already been deprecated. Any deprecated content pack that you have installed will remain in your account, but no documentation or support will be provided for it, nor will it be possible to install it again."

For powerbi, there are three ways to export data as follows:

• Exporting data from Power BI dashboard
• Exporting data from a Power BI report
• Copy the table in Power BI Desktop

For more details, you can read below document:

Explore your Application Insights data with Power BI | Microsoft Power BI Blog | Microsoft Power BI

3 Ways For Exporting Data From Power BI: A Complete Guide - Learn | Hevo (hevodata.com)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rpatil]

Sorry this method doesnt work. Do you know whats the best practise for exporting data from application insights to power bi

[amitchandak]

@rpatil , Check if you can paginate to get more data

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78