Forum Discussion
Connection to aws rds mysql
Memorable MemberHi 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!
Yep, I want to create an automatic refresh on https://app.powerbi.com/.
From the link, you sent me, I made the conclusion: I have to create an additional server with some PBI soft, and without it, I can not connect to AWS RDS MySQL --- am I right?
- KBO
Hi Anonymous ,
ok then we talk about Power BI Service! Not Report Server - both are very diffrent :).
You can use a virtual machine which is 24/7 online or on the times of the refresh and then you can configure your refresh thats rigth.
The conclusion from the other issue was for report server :).
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!
Could you clarify what exactly should be installed on that VM?
As I understand: this should be a windows VM with an "on-premise gateway" installed.
Am I right? Or I need to install some other software related to PBI?
Also thanks for the comment about the PBI report server, and PBI Service. I just mixed this thing up.
If you will be so kind, please, clarify this thing in a couple of words:
1. How can I determine what I am using (service or report server).
2. What should I use to achieve my goal (auto-update of data in the report).3. Does connection to AWS rds MySQL differs for report server and service?
Thanks, now things becomes much clearer!
- KBO
Hi Anonymous ,
As I understand: this should be a windows VM with an "on-premise gateway" installed.
You also need to store your data there 😉 otherwise if your laptop is not online your datasource wouldnt available 😉
Gateway is also usefull to connect the datasource from your vm to Power BI Service. Another good methode or more common ist to have your datasource an a on premise server which shouldn't be have downtime and is online 24/7 :).
Am I right? Or I need to install some other software related to PBI?
1. How can I determine what I am using (service or report server).
The Power BI Report Server is a on premise solution which must be installed seperatly. Also you need the additional PBI Desktop for PBI Report Server. Last version is from October 2020. If you find no Power BI Report Server Upload under save under than you have the cloud client ;).
2. What should I use to achieve my goal (auto-update of data in the report).For Power BI Servie or Report Server?
3. Does connection to AWS rds MySQL differs for report server and service?
You can use MYSQL but you need the additional driver for the Report Server 🙂
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!