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 

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.

      • venal's avatar
        venal
        Icon for Memorable Member rankMemorable Member
        6 years ago

        ramon74 

        If it is SQL Server, Please refer the below link to know the supported versions.

        https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites

        If you have any queries, please let us know.

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more
        If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

         

        BR

        venal.