Turn off refresh data during modeling / data shaping

[Anonymous]

I am using the desktop client and pulling data from an  azure sql data warehouse.  The main table has 10 million records and everytime i edit the query / modify the model, it has to requery the main table....Is there a way around this? I have tried all different combinations of "Enable Load"...."Enable Refresh"...

[jaykilleen]

I am curioius to know if anyone with this issue has tried running a DEV database instead of pulling from LIVE (ie SQL Server).

My thought is to create a variable called 'environment' where I can change it from 'development' to 'production' and if the environment equals development then I point my data to local stored copies of the production database.

Sort of like a seed data but populated using real data from the system.

Would this speed up my dev process? I think it would as it would pull the data from excel files. I can then have those Excel files pull from SQL Server using the basic power query scripts that my Power BI queries would use when in the production environment.

Anyone care to comment? That would be great.

[meysun · Accepted solution]

It will only load the data when you swich to Report canvas. May be during the development type if you don't need all the rows, then in query window you can choose to keep only the top n rows. After all the development is done, then you can remove this step in the query window.