Help with Custome SQL re-use

[VineetaSirohi]

I am working on a migration project from Qlikview to Power BI. There is SQL query which I am using as custom SQL in my reports. This same query is being used in multiple reports and took little longer to execute. 

Is there a way where I can define this Query only once and re-use its output into other reports along with other tables/queries without refreshing it.

Thanks,

Vineeta

[camargos88 · Accepted solution]

Hi @VineetaSirohi ,

You can use Data Flows for it, you just need to refresh from the source when necessary and other reports can consume it.

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-serv...