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
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.