Forum Discussion

jgores77's avatar
jgores77
Regular Visitor
8 years ago

Possible memory leak?

  Hello,   I'm running a DirectQuery to a database using 4 tables from the same database.  When I try to add latitude and longitude columns from one of the tables, it adds them fine, but creates a...
jgores77's avatar
jgores77
Regular Visitor
8 years ago

Hi Anonymous/Xiaoxin,

 

I thought this might be the case as well, so I limited the data to a single year using the Page Level Filter (reducing my rows of data from 600K to about 14K) and deleted all calculations.  Power BI still does the same thing.

 

Any other thoughts?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI jgores77,

 

If you only drag that column to visual and do same operate it, do this issue appears?

If your create new report or test with other device, did these operations spend less memory?

 

Regards,

Xiaoxin Sheng

  • jgores77's avatar
    jgores77
    Regular Visitor
    8 years ago

    Hi Anonymous,

     

    If I create a map with the same fields in the tooltip, I can add everything I want without any issues.  However, in the spreadsheet view, the memory issue happens over and over.  My manager tried the file on his machine with the same results.  Here's a screenshot from his machine:

     

     

    His memory also goes to 94%+ as well.

     

    I've uninstalled and reinstalled Power BI as well and have tried an earlier version on Power BI and the issue occurs each time.

     

    I'm happy to share the file if that would be of help.

     

    Thanks!

    Jim

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI jgores77,

       

      I also not sure why this appears, please submit a support ticket to get more support from power bi team.

      submit a support ticket

       

      Regards,

      Xiaoxin Sheng

      • jgores77's avatar
        jgores77
        Regular Visitor
        8 years ago

        Hi Anonymous,

         

        I'm not a Pro user and thus I can't submit a support ticket.  I won't be able to become one for a few more months since I work for a government agency and we are in the process of moving to Office 365.  I've found a workaround outside of Power BI, so I'll hold onto this issue for now.  Maybe future updates will fix it, if not, I'll submit a ticket when I become a Pro user.

         

        Thanks!

        Jim