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
    Icon for Memorable Member rankMemorable 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!

       

      • KBO's avatar
        KBO
        Icon for Memorable Member rankMemorable Member
        5 years ago

        Hi Anonymous ,

        ahhh ok I understood. So your report is nowonly running on you laptop in Power BI Desktop and not on Power BI Report Server or Power BI Service?

        But the gateway thing make me think you use the Power BI Service (app.powerbi.com)?

        Here is a simillar topic: https://community.powerbi.com/t5/Report-Server/Connection-problem-to-MySQL-data-source-from-PBIRS/m-p/317019

         

        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!