Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Connection to aws rds mysql

Hi all,   I am new to PBI and I am facing a problem with the connection PBI report server with AWS rds DB on MySQL. I have read a lot of articles and came to the conclusion, that I need to install...
AWS RDS
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks!

    But I didn't find AWS RDS MySql in the list, which you proposed to me.

    Maybe I should clarify a bit about my problem:

       I have a PBI desktop file, Also I have a PBI file on the report server, and when I need to update the file on the server, I need to do 2 operations: 1) refresh in desktop file --- just to get data in graphics updated.

                                             2) publish in desktop file ---- publish the file to report server.

    As the data source for my PBI file, I use the AWS RDS MySQL server. 

    So, I want to automate these things. And I found out, that in the file on the report server I can do an automated refresh. I tried, but unfortunately, I understood, that without gateway I can't do it (or at least don't know how to do it).

    So, I wonder why it is so? Why I should use an additional server for installing on-premise, while my RDS server always online? And why in desktop version all works well?
    If anyone can help me, I really appreciate it.

    Thanks, guys!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        PBI report Server

    • KBO's avatar
      KBO
      Memorable Member
      5 years ago

      Hi Anonymous ,

      I only told you that you find all possible connections in the list above ;). 

      If you have already connect, which connector do you use to do it?

      Normally on premises you don't need any gateways because the Report Server is on premises like your data ;).

      It can be that you need to install a seperate driver to run the automation on the Report Server. Thats why I ask you which connector you used. 🙂

       

      Best,

      Kathrin

       

       

       

       

      If this post has helped you, please give it a thumbs up!
      Did I answer your question? Mark my post as a solution!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Oh, I am sorry. I just new to PBI and not all things are clear to me, that's why I misunderstood you.

        In my desktop file I used the MySql database connector:

        There I just put rds endpoint and credentials...

        But I tried to do the same on the report server --- it didn't work. I had to install on-premise data gateway software on my local computer, and then it worked, using my computer as a gateway.

        So, I want just to share my PBI file with my teammates and I want to give them only the RDS endpoint and credentials.

        I don't want my computer always running just to supply gateway. If there is any way to do this, I would be so happy ☺

        Thanks for your patience!