He he ..that`s the mission in front of you
Of course you can not simulate the real scale of powder. I think you should use BULLET but I am not sure how will behave calculation with big amount of objects.
Can be also done with Volumetric or better: particles I think.
But I am really not sure how do it.