Forum Discussion

RAY_DEV's avatar
RAY_DEV
New Member
6 years ago

Limitation on rows imported from SQL Database into Power BI Desktop

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!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.