Resources exceeded issue - is this related to load data from view or table ?

[Anonymous]

Hi there,

I have an import mode from sql server, and now i need to have direct query mode within the same server.
with import mode, 230k records are loaded and there is no issue. I'm calling a view object from sql studio.
In the same database, i have a similar view object which has 230k records and i want to connect to this specific view with direct query. In pbix after 10-15 minutes I can see data is loaded, in the workspace it's not even working (see below) 

I heard using views instead of tables is better in power bi, is this related to view or table ?
how can I fix this problem ?

thank you.

[Anonymous · Accepted solution]

You're right, in the query i'm returning couple of subqueries and that makes things close to impossible. I didn't even need them so i took them out and it works perfectly fine. 

[lbendlin]

The issue is likely caused by your joins, and potential cartesian products. Check the cardinality of the join columns.