Forum Discussion

latearrival's avatar
latearrival
Advocate I
6 years ago
Solved

How to refresh dataset on Power BI Service from Azure MySQL database

Hi all. I've got a report that is based on data from an Azure MySQL database. Everything's working fine on PBI Desktop. But I can't refresh the dataset on the PBI Service.  When I click 'Refresh now...
Need Help
  • latearrival's avatar
    latearrival
    6 years ago

    To answer my own question, yes, you need to install the data gateway in order to refresh a dataset on Azure MySQL.

     

    In our case, we don't have on-premises servers, so we've installed the gateway on an Azure VM.

latearrival's avatar
latearrival
Advocate I
6 years ago

venal

Before I try that, woud you mind confirming my understanding please. Are you saying that I need to install a data gateway in order to refresh the dataset from Azure MySQL?  

It seems crazy that an Azure service (PBI) needs locally installed software (a data gateway) to be able to retrieve data from another Azure service (Azure MySQL). Both cloud-based (not on-premise) and both running on Azure. It doesn't make sense to me.

latearrival's avatar
latearrival
Advocate I
6 years ago

To answer my own question, yes, you need to install the data gateway in order to refresh a dataset on Azure MySQL.

 

In our case, we don't have on-premises servers, so we've installed the gateway on an Azure VM.