Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
Iam getting bit confused in understanding is there any limitaiton of no.of rows imported in PowerBI desktop
regards
Ramanathan
Hi @unleashPBI,
There is no official document points out the maximum number of rows imported to Power BI desktop. I have sent a email to consult this from PG internally, will keep you updated if I get information.
Best Regards,
Qiuyun Yu
Hi @unleashPBI,
I got the information below internally:
Neither Power Query nor Power BI Desktop have a strict limitation on the number of rows.
Best Regards,
Qiuyun Yu
There is no hard limit documented. But you may hit the limitation of Power BI Desktop as Windows application first (out of memory), when you import a lot of data. Also, keep in mind there is a hard limit of 1 GB for .pbix file size that can be published to Power BI Service (the .pbix file itself can be much larger). I think they are working at Microsoft to make this limit higher in the future.
Just to give you an example - some of my clients work with tens of millions of rows imported into Power BI Desktop file. But if you hit the limit - if your desktop machine goes out of memory - you can move the data to one of the databases for which Power BI supports live connections (DirectQuery, more: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |