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 ...
  • amitchandak's avatar
    4 years ago

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