Limitation on rows imported from SQL Database into Power BI Desktop

[RAY_DEV]

Hi all,

I'm struggling with a subject and I need your advices. 

I've imported a list of tables and created relationships between them, active and inactive. 

For a table, let's call it PROJECT_TASK, I have 4200 rows on the SQL table, when I check the SQL database. But I can see that Power BI imports only 1900 of them. I'm not putting any additional filters other than relationships. 

I can find data on the SQL table that is not available on the list of rows of the table in Power BI Desktop. 

Is there a limitation somewhere about the no of rows we can import into Power BI Desktop when connecting to a data source? 

Is the relationships we build filter the data prior to any vizualizations? I'm just looking to the "Data" section of the tables and I can see it has imported less rows than what is available on the SQL database. 

Thank you!

[Anonymous]

Hi @RAY_DEV ,

It's strange. Try delete the relationships and see if the count of rows is correct.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.