Is it possible in the query editor to make a copy/duplicate of a query?
This "mother" query must feed the copy/duplicate with new data when it is refreshed. But it is important that the copy/duplicate doesn't refresh (connect to the datasource) itself.
I will try to explain. I have made an embedded Power BI report for a customers site.
We used to pay Microsoft(Power BI Premium) 600 euro every month for running this report. It has a refresh schedule (it is refresh every hour) and the customer can manually refresh.
But now the data that is pulled in every refresh is getting more and more and we had to upgrade Power BI Premium and now we have to pay 1200 euro every month.
I have one query that pulls in 700.000+ records every time the report is refreshed.
I need to model the data from this query in 5 different configurations to build the report. So I now use the same query 5 times, that means that those 700.000+ records are pulled in 5 times on every refresh.
What I like to have is that the data is pulled in once and that the data is written to (4) other tables in the Query Editor so I can model these 4 for my report.
I know it is possible with DAX but with DAX I have to little tools to model the data further, it need the Query Editor for that.
In my experience, for reports with frequent update/refresh, you almost never need raw data with 700k rows. You can usually set up View, on-premise stating server etc to perform data aggregation and reduce payload before hitting BI Service.