Forum Discussion

akhaliq7's avatar
akhaliq7
Post Prodigy
4 years ago
Solved

refreshing data from a sql view and having added transformations in power query slowing down my refr

I am connecting to a oracle database, I get my SQL view into Power BI, I then need to get another sql view i do transformations on that need to do a left join on the 1st query, query folding has not broken for either query, i untick the enable load for the second query. I do some more transformations on the first query, query folding is still enabled but my data is taking too long to load. 

 

Question: Are sql views usually this slow should I be using some other datasource heard data warehouses can be decent,

 

 

  • akhaliq7 , SQL View or Query performance will depend to database and how optimized the query is. It is always better to have table

1 Reply

  • akhaliq7 , SQL View or Query performance will depend to database and how optimized the query is. It is always better to have table