Disable Refresh

[FilipeSantos_pt]

Hi, 
I am new to Power Bi so I hope I will be explicit enough with my doubts..

I am working with SQL Server database however I find real annoying that every step I make Power Bi desktop has to refresh the data and update the visuals. I prefer that it just stops doing that after the first load of data and after that only work with that "sample" and if I need I just turn on the refresh. Also this affets me when working offline that I can't do anything because is always trying to connect to the database.

Thanks in advance

[londonmap]

 the second method works perfectly with direct entry models.  You have saved me a huge amount of time.

Thanks....

[Greg_Deckler]

@FilipeSantos_pt Are you referring to when you are in Power Query? Are you in import or Direct Query mode?

[FilipeSantos_pt]

@Greg_Deckler I am on import mode. 

I am trying to do an Income Statment Report and, on this phase, I am not working with real time updates of the report.

For example, every time I create a new measure or just hit ESC on an empty measure that I accidently created the report tries to refresh and, since I am offline, it starts to generates errors:

"Something went wrong"

because it wasn't able to connect to the SQL Server and even though I hit cancel it generates this error message 5 more times. And until it really stops it takes a lot of time before it allows me continue with my work. The changes are in a pending state that I will apply when I get online.

I don't know if this helps but from the previous answers to this post I am getting the idea that I can't avoid this.

[Greg_Deckler]

@FilipeSantos_pt What does not make sense is that you keep referring to measures and this while in import mode. Are you in the Power Query Editor when this is happening or are you in the Desktop? Power Query Editor:

[Sumanth_23 · Accepted solution]

hi @FilipeSantos_pt ,

One approach is to create measures in the Data view; this way reports/visuals will not refresh everytime you create a new or exit from an existing measure as seen in below screen grab

Another approach you can try is to create/edit measures with a focus on an empty report sheet.

This way visuals will not attempt to refresh everytime you create a new or exit from an existing measures

I have tried this approach with a report file with imported data and a report connected to a live dataset but out of network - and I am able to create measures without any errors. 

Let me know if I am missing any steps you are performing. Thanks! 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

[Sumanth_23]

hi @FilipeSantos_pt  - If you connect to the datasource with "import" mode, then Power BI would import a copy of the data into the report file and you can work on the report.

This would also allow for working offline when you are not connected to the database - as seen in the below screen grab 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

  

[pranit828]

Hi @FilipeSantos_pt 

Datase is the source of truth for all the reports that you do, same case as it is in excel.

Unless the repot doesn't know the current datatype and various other things you can do on power query, how will it be able to determine the measures and columns you create.

It is not possible to bypass this process when it does.