Why wouldn't PowerBI desktop make me update automatically?

[Anonymous]

Hello, 

I hope you will be able to help me out - im trying to make my PowerBI update automatically once a day. 

I've opened my semantisk model and under settings i found the "update". 

But the problem is that there is no way i can click on "on" apply automatically updates. 
It's like it is unclickable, and i how no idea why?

I have done it on a previously report, and i haven tried to delete that one.
But nothing is helping, can you help me out?

Picture is in danish, but as you can see the bottom is like grey and unclickable. 

Best regards
Rasmus

[Uzi2019]

Hi @Anonymous 

Try to setup the gateway setting first then refresh otpion will be enabled to you.

I hope it helps you!

[Anonymous]

Hi again, 

I have tried to connect the gateway - but it seems a bit weird imo. 

Its automatically jumps to a personal cloud connection, even tough i entered all the needed SQL informations. 
I can't click apply or anything?

Still not possible to click on refresh section.

Any clue?

[Anonymous · Accepted solution]

Solved! 

Since i had both SQL server and file on onedrive - i had to create a personal gateway.