Showing results for 
Search instead for 
Did you mean: 
pstanek Member

Maximum capacity for rows of database.

HI. We use MS Azure as database. Database has milions rows. Power Bi use Direct query.


I don´t know if we set up connection wrongly , but  now calculations are too slow . Analyse in Excel is impossible.What is the limit for rows of data for database. Is it possible to make it faster?

Moderator v-caliao-msft

Re: Maximum capacity for rows of database.

Hi @pstanek,


There is currently no limit on the rows of data you can import into Power BI. There is a 10 gb Per user size limit for pro user in Power BI services.


And the speed depends on your datasource and architecture. Here are some tips for you reference.
•Hide or unhide columns in your dataset.
•Use a mix of data types such as names, times, dates, and numbers.
•Avoid (or hide) columns with duplicate information.



Charlie Liao

pstanek Member

Re: Maximum capacity for rows of database.

You mean hide in Query editor, or directly in database

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)