Refreshing Azure SQL DB

[DrewSmith]

I've got an Azure subscriptions setup that includes a DB and some data pipelines. That's all working fine and I can import the data into Power BI. 

In the service, however, I cannot seem to have the data refreshing. I've installed a Personal Gateway and that's worked, but I cannot leave my laptop on all day every day to refresh. Surely as both are cloud services there should be an automatic way to have this refreshing?

[DrewSmith]

Nevermind, looks like it may have been to do with the credentials I was passing in the PowerBI Service. Sorted now. 

[v-rzhou-msft · Accepted solution]

Hi @DrewSmith ,

If you need to make your Personal gateway work scuccessfully, you need to keep laptop on.

As far as I know, Azure SQL Database should be the cloud data source.

I think you can try to edit the data source credential in Power BI Setting > Semantic Models > Data source credential.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.