Forum Discussion
Limit to number of rows exported to PowerBI?
I am trying to create some PowerBI reports for my customer (no, I cannot use workbooks) and in order to get some good charts I need to be able to import a large number (1M+) number of rows but it seems that I get only about 100K at most. Does anyone know if there is a limit to what Log Analytics will allow to be exported at one time (kind of like the 10K limit on the number of rows you can see when querying the logs)?
5 Replies
- CliveWatson
Microsoft
10k for the query (as you mention), 500K for the api https://docs.microsoft.com/en-us/azure/azure-monitor/service-limits - so you may need two bins - each at 500k ?
CliveWatson Thanks, I read about that limitation in one page I was looking at. For some reason I cannot even get the 500K.
I must be running into the size limit of 64Mb since if I just return 1 column I get my 500K rows. 😞
