What is currently table row limit for Power BI Desktop?

[BirhanAYDS]

Hi everybody! Please just say what is the row limit each table for Power BI Desktop currently? It's about Import mode. 

[amitchandak]

@BirhanAYDS , As per Power Bi doc following are the limits. For premium check on the link

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-what-is

Considerations and limitations

For all data sources used in the Power BI service, consider the following limitations. There are other limitations that apply to specific features, but the following list applies to the full Power BI service:

• Dataset size limit - There's a 1-GB limit for datasets stored in Shared capacities in the Power BI service. If you need larger datasets, you can use Power BI Premium.

• Distinct values in a column - When caching data in a Power BI dataset (sometimes called 'Import' mode), there is a 1,999,999,997 limit on the number of distinct values that can be stored in a column.

• Row limit - When using DirectQuery, Power BI imposes a limit on the query results that are sent to your underlying data source. If the query sent to the data source returns more than one million rows, you see an error and the query fails. Your underlying data can still contain more than one million rows. You're unlikely to run into this limit as most reports aggregate the data into smaller sets of results.

• Column limit - The maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns. This limit applies to the Power BI service and to datasets used in Power BI Desktop. Power BI tracks the number of columns and tables in the dataset in this way, which means the maximum number of columns is 16,000 minus one for each table in the dataset.

[AllisonKennedy · Accepted solution]

See this article: https://docs.microsoft.com/en-us/power-bi/connect-data/service-get-data

Limit of 1,999,999,997 distinct values in a column. 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv