cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Problem with loading data into POWER BI DESKTOP

Hi,

 

I am having trouble loading a large data set into Power BI desktop.The data source i have used is MongoDB. I am using the ODBC driver to load the data.

 

It is taking too much time to load data and then gives the error: "there are not enough memory to load the data".

 

Is POWER BI desktop having some kind of limitations for size of data to be load into it?

 

 

Thanks,

Axata

7 REPLIES 7
Highlighted
Super User III
Super User III

Re: Problem with loading data into POWER BI DESKTOP

@axata It is probably the memory on your machine that is the restriction. How large is the data as it sits in MongoDB?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Highlighted
Helper I
Helper I

Re: Problem with loading data into POWER BI DESKTOP

My Data which are stored in MongoDB is containing the almost 6 crore data in it. and the size of the file is 6.73 GB.

Highlighted
Memorable Member
Memorable Member

Re: Problem with loading data into POWER BI DESKTOP

Hi @axata,

 

I think the issue is with RAM.

 

Thanks !!

Highlighted
Community Champion
Community Champion

Re: Problem with loading data into POWER BI DESKTOP

Also want to just check an easy missed variable too.  Are you using 32bit or 64bit version of Power BI?

Highlighted
Helper I
Helper I

Re: Problem with loading data into POWER BI DESKTOP

I am using the 64bit version of POWER BI.

Highlighted
Responsive Resident
Responsive Resident

Re: Problem with loading data into POWER BI DESKTOP

@axata: It's your system RAM issue.

 

There is 1 GB compressed size limitation for .PBIX file.

 

 

 

Highlighted
Microsoft
Microsoft

Re: Problem with loading data into POWER BI DESKTOP

Hi @axata,

There are some proposals for you solving this issue.

1. Increase the amount of memory available on your machine.
2. Increase the size of “Maximum allowed” as shown below in Power BI Desktop.
1.PNG
3. Import essential columns and rows of your data source to Power BI Desktop, and optimize your data model following the guide in this blog, the blog also applies to Power BI Desktop.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors