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 see...
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. 😞
Are you able to summarize the data in some way (I know this reduces the accuracy for PowerBI) but do they really need 1m rows? Just a small change helps...
AzureActivity | project ActivityStatus AzureActivity | summarize count(ActivityStatus) by bin(TimeGenerated,1s)Go to Log Analytics and Run Query
In the above Query #1, it hits the 10k limit, Query #2 returns 6681 with just a 1s bin.
CliveWatson Thanks again. I'll see what I can do to adjust the needed queries.
