Forum Discussion
Power BI: Importing a huge dataset from MongoDB SQL Connector
Super UserHello tenderd ,
try to limit the data from sql and load the 25000 rows =, like by creating a view that has the rows and columns you only need.
also try using star schema data model https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡
I cannot Query data like SQL here and restrict it. I am using MongoDB SQL connector here so all data from the database is loaded here then I filter out the data I need in power query. I do not see any option to create "match" / "project" nosql pipelines to filter exactly the data I need before it comes into power query.
However, if you think it is possible to apply filter and limit data, let me know. I would be happy to learn.