Forum Discussion
Connection to aws rds mysql
Oooh, maybe I am asking not very clever questions, but I am confused a little bit:
I will try to explain my situation more clear:
1. I have the data source as AWS rds MySQL --- this source is always online (as I know ☺), because at any time I can connect to this DB by the workbench.
2. I can connect to this DB from the desktop PBI file.
3. Also, I can do the refresh on the PBI service by following steps:
1) refresh the desktop PBI file
2) publish the desktop PBI file.
My goal: automate updating on PBI service.
As I understand: you are saying I should place my DB in VM?
I thought I just should create a Windows VM and use it as a gateway for PBI service (by installing on that VM "on-premise gateway" soft or anything else). I did something similar by using my local machine as a gateway, and it worked! But I just don't want my computer always running to supply a gateway for the PBI server.
Also, AWS RDS MySQL --- doesn't it on-premise server? (I am sorry, maybe it is a very stupid question)
Memorable MemberHi Anonymous ,
may be I'm also confused XD
Yes you need a gateway on your VM to your Datasource for the automated refresh.
And redshift isn't supported on Power BI Report Server :). Only MySQL so I'm cunfused about the data source ;).
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!
Ok. Thanks!!!
I will try to create a Windows VM with the gateway, and we will see, whether it will work ☺
Thank you for your great answers!
If it will work out, I will mark your answer as the Solution.
- KBO
If you have further questions please reach out to me ;).
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! Also one little question: What do you mean: "only MySQL"? and on "report Server"? because as I understand we are talking about PBI Service?
Do you mean, that I chose not a very good DB for my data source? Could you please give me an advice? (I am very new to all this stuff).
- KBO
Hi Anonymous ,
no its all good 😄
please use cloud If you can ...the Report Server (on premise solution) has less feature than the cloud.
Do you have a choise in your database? Otherwise I would always prefer MSSQL :).
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!Best,
Kathrin