Direct Querry from SQL graphs loading very slow

[MindaugasJ]

Hi,

I have two different querries from SQL database.

I'm using direct querry.

I haven't made any transformation to uploaded data to power querry.

The first querry works fine. In report view when creating new graph and adding parameters - graphs updates instantly.

But the problem is with second Querry. In Power Querry all the data loads fast.

But in data view the second querry doesn't show this querry table.

And in report view when creating any type of graph and adding parameters - loading of one parameter takes several minutes.

What could be the problem and how to solve it?

[MindaugasJ]

@lbendlin what do you mean? In power querry aplied steps I see the same first step..

[lbendlin]

Your problem is on the SQL Server side, not in Power Query.

[lbendlin]

I haven't made any transformation 

Oh yes, you have .  You are running a stored procedure, and a SQL view.  Look into the query plan for both of these.