I tried to get data from the Power BI semantic model in Power BI Desktop, but it shows the same result — it does not display the complete dataset, only the column headers
Did you try to put the data into a mysql or other database / file (excel/csv) and make a insert using connection inside the PIB to test it too? To understand the possibilities and limitations, if the problem can be the node or the data transfer/dataset?
Normally, I recommend to put the data into a database in cloud or local and consume it on demand, to not inject it directly into PBI and have some space and process problems.