Solved: Refresh from Excel does not work - no error messag...

_Kristina_ · ‎10-24-2017

Hi!

I'm having trouble refreshing my report in Power BI desktop. My data is from Excel (through get data). It has worked earlier. When I hit the refresh button in desktop it starts refreshing, but when each Excel sheet is on 80 something kb, it just stops. I get no error message or anything, and nothing is updated.

Anyone who have the same experience and know a good solution to this problem?

PS: I tried updating my version yesterday.

_Kristina_ · ‎10-26-2017

Thanks @v-chuncz-msft!

I actually found my problem and it was that I had moved the original file to another folder. The path had to be changed in the Query editor under options. When this was done I could refresh easily.

This can be helpful for another time, thanks anyways.

View solution in original post

v-chuncz-msft · ‎10-26-2017

@_Kristina_,

Check "Include in report refresh" in the Query Editor.

https://community.powerbi.com/t5/Desktop/All-queries-not-refreshing/m-p/235864#M104964

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

_Kristina_ · ‎10-26-2017

Thanks @v-chuncz-msft!

I actually found my problem and it was that I had moved the original file to another folder. The path had to be changed in the Query editor under options. When this was done I could refresh easily.

This can be helpful for another time, thanks anyways.