Forum Discussion

Ryszard's avatar
Ryszard
Frequent Visitor
8 years ago

Not enought memory

Hi there.   I am quite new PowerBi user without experience with DAX and SQL. My issue is linked with PowerBi command Not enought memory during SQL data importing to PowerBi.I executed some communit...
Need Help
Keith_H's avatar
Keith_H
Advocate I
8 years ago

This thread shows how to build the SQL into your query - writing it should be pretty straightforward, something like

 

SELECT * from [YourTable] where [DateYourInterestedIn] >= DATEADD(year, -3, CURRENT_TIMESTAMP);

 

depending on what your server is runing and how much data you want to pull

Ryszard's avatar
Ryszard
Frequent Visitor
8 years ago

Thank you for prompt reply.

 

I tried your code but, there is a syntax error. Anyway i use column filter properties(date/time filters), but it seem that there is still to many records for PowerBi/available memory to load (i loaded data from 2017-12-29 and when i try 2017-12-01 memory limitation message appear) 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Ryszard,

    When you use SQL statement to filter your data, please test using SSMS, then type the accurate SQL statement in the red line box.



    Best Regards,
    Angelia