Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
akhaliq7
Post Prodigy
Post Prodigy

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,

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors