Forum Discussion

GaryBushey's avatar
GaryBushey
Bronze Contributor
Dec 11, 2019

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...
GaryBushey's avatar
GaryBushey
Bronze Contributor
Dec 11, 2019

CliveWatson Thanks, I read about that limitation in one page I was looking at.   For some reason I  cannot even get the 500K.

  • GaryBushey's avatar
    GaryBushey
    Bronze Contributor
    Dec 11, 2019

    I must be running into the size limit of 64Mb since if I just return 1 column I get my 500K rows.  😞

    • CliveWatson's avatar
      CliveWatson
      Former Employee
      Dec 12, 2019

      GaryBushey 

       

      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.  

      • GaryBushey's avatar
        GaryBushey
        Bronze Contributor
        Dec 12, 2019

        CliveWatson Thanks again.  I'll see what I can do to adjust the needed queries. 

Resources