Forum Discussion

MindaugasJ's avatar
MindaugasJ
Frequent Visitor
3 years ago

Direct Querry from SQL graphs loading very slow

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?

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    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.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

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