need some suggestion - fetch data from view in sql server hourly ?

suvechha  if you are on premium workspace create a dataflow where you write a native optimized sql query to return the data from sql view and have that scheduled to refresh every hour. What works for me is not using PQ for any of the transformation, rather doing it through native sql to do the heavy lifting.

Create a seperate pbi report where you query that dataflow to build a report. Publish that in the workspace and have that refreshed every hour with an increment of 30 min from the data flow. In this way you can run the transformation and reporting parallely and optimize.