Why SQL query import only 4600 rows from 49000 rows?

I have created one SQL query, which includes 49000 rows of data, 980 rows of T-SQL and consisting more than 10 UNION queries in T-SQL. SQL query works fine when I run in SQL Management Studio.

I try to get data to Power BI Desktop from SQL Server using this SQL query. I get no errors, but table includes only 4600 rows. I get no errors!

Is there limitation of how many rows can be imported with SQL? Is there limitation with how many rows can be inserted to SQL editor in Power BI? Is there limitation with using UNION commands?