Maya

One day Narada comes to Dwaraka and asks Krishna to explain to him what Maya is. So Krishna takes Narada on a trip in the desert. In the middle of the desert, Krishna asks Narada for water, as he (claims to be) feeling thirsty. Narada goes a short distance and finds a nearby village, where he falls in love with a local village girl and forgets all about Krishna. He marries her, has children, and lives wit them 12 years. Then one a massive flood comes and his family is washed away, when suddenly he hears a voice saying "Narada, what about my water." He sees Krishna, and asks him what has happened to his wife and children. Krishna says that none of it was real, that Narada never had a wife or children and that the village didn't even exist. That is what Maya is.

Source
Matsya Puranas

In this account Narada asks Vishnu, not Krishna, what Maya is, and then Vishnu tells Narada to take a bath in a pond, after which Vishnu will take a bath. Then Vishnu turns Narada into a woman and makes him forget who he is, so the woman falls in love with a king, has children, and then her children die in a war. Finally Narada goes back to the pond, where he regains his male form, whereupon he hears Vishnu say "Narada, why are you still standing in the pond?" So then Vishnu explains that his experiences weren't real and that that is what Maya is. But the Devi Bhagavatam is considered by many to not be an authentic scripture, because it's not listed in the traditional lists of Upapuranas. So does anyone know if other Puranas mention this story of Vishnu and Narada?

Source
Devi Bhagavatam.

https://en.wikipedia.org/wiki/Sri_Krishna_Maya
https://www.youtube.com/results?search_query=narada+maya
https://www.slideshare.net/search/slideshow?searchfrom=header&q=narada+maya
http://daily.bhaskar.com/news/JM-MYTH-narad-muni-woman-story-5502965-PHO.html