Forum Discussion
Out of Memory composite model/Direct Query.
Hi all,
Getting out of memory (ram) with Direct Query.
I was reaching the data size limit (1 gig) with my model using import and I knew that in future it was going to get bigger. So I switch to a mixed model design. Where only the large table would be direct Query.
After this I got, two major issue. The first being perfomance just tanked. I assuming this is primarily the backend DB just wasn't up to the task. I also am ware that the report itself could do with some tuning to fit the composite connection model.
The issue I am suprise with though was that of the Out of Memory/RAM preventing many of the visuals that would load with import method.
Any thoughts?
Hi Anonymous ,
What datasource are you using?
Here is a similar blog for your reference.
3 Replies
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Hi Anonymous ,
What datasource are you using?
Here is a similar blog for your reference.
