Forum Discussion
Disable Refresh
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!
FilipeSantos_pt Are you referring to when you are in Power Query? Are you in import or Direct Query mode?
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.
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!
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: