Forum Discussion
Ryszard
8 years agoFrequent Visitor
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...
Ryszard
8 years agoFrequent Visitor
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
8 years agoMicrosoft Employee
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