Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Getting Live data from MySQL

Hi , I have a MYSQL as Datasource from which I pull data created some custom calculated column and now implemented it using Power Bi visuals. Now I am facing issue in seeing the Live data. To see ...
Gateways
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

As the MySQL is on-premise data source, after publish the report to service, we need to configure the dataset to use on-premises data gateway. You can install the on-premises data gateway follow this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem. Then create a MySQL data source under gateway and configure the dataset use the gateway follow this: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-scheduled-refresh

 

You can set the Schedule Refresh for the dataset, also you can click Refresh Now to refresh manually. After the dataset is refreshed, we can open the report and data are updated. But if we open the report before dataset is refreshed, we need to click Refresh inside of the report or refresh the browser page to see the updated data. 

 

Best Regards,
Qiuyun Yu 

  • ramon74's avatar
    ramon74
    New Member
    6 years ago

    Buen dia, creo que estan tocando dos temas distintos en este hilo, una cosa es MySQL y otra es SQL Server, Yo tengo un problema similar al del mensaje original, tengo mi base de datos en un servidor de base de datos de la empresa, necesito que mi informe que esta en la nube de power bi se conecte al servidor de MySQL para que se actualice, pero me pide que instalar el Gateway en el computador donde tengo el poqer bi desktop, el problema es que si tengo el computador apagado, suspendido o fuera de línea por cualquier razon, el informe de la nube no se actualiza. Debe haber alguna forma de conectar el informe que esta en la nube con mi servidor de base de datos MySQL corporativo, puede alguien decirme como????

    • adrian_romoS's avatar
      adrian_romoS
      New Member
      4 years ago

      Hola Ramon, pudiste resolverlo, tengo el mismo caso

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Qiuyun,

    I have SQL server 2008 R2 version and I am unable to setup Enterprise gateway for this. Do I require newer version os SQL server or 2008 should be compatible for gateway. Objective is to schedule a refresh of my data.

    Thanks,

     

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      Hi Anonymous,

       

      Please not below points:

       

      1. On-premise data gateway only have the 64 bit version currently, make sure your SQL Server is 64bit as well. 

      2. Make sure the machine which hosts on-premise data gateway can access SQL server. 

       

      If from the machine hosts your current installed gateway, you can access SQL server. You can create a SQL data source under Manage Gateways without installing new gateway. See: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

       

      By the way, it seems this question is different from the original question. I would suggest you post different issue in a new thread next time. If the original issue is solved, would you please mark a helpful reply as an answer? Thanks. :smileyhappy:

       

      Best Regards,
      Qiuyun Yu 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Thanks for the response, the question was to schedule a refresh with SQL server as database and I went through the article you shared in first response and there they have mentioned 2012 Sql version is only supported. I am stuck now how to go ahad with 2008 R2 server as client is not ready to upgrade the Sql version.