Refresh powerbi online with SQL data base RDS AWS

0 votes
I have set up a power bi. I have connected it with the rds database (aws). the report is published online. I have a problem with the update of the data. Every time I launch the update I get the following error message:

Guid must contain 32 digits and 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)

Can you help me to find a solution?

Thanks
Mar 14, 2022 in Others by Edureka
• 13,690 points
1,201 views

1 answer to this question.

0 votes
It must connect to the database successfully in order to refresh the Power Bi Visuals on the Web Application. Because the AWS database server is installed on an AWS Virtual Machine, this acts as an on-premise source on that machine when connecting to an AWS RDS instance [6]. As a result, you'll need to set up an on-premises gateway on an AWS server with access to RDS, either within the same VPC or using appropriate security standards.

The steps for setting up an AWS on-premise data gateway are as follows:

Create an EC2 Windows instance; for additional information, read the AWS manual [3]. For further information about the instance(s) depending on the operating system requirements, see this public Microsoft link [4]. The instance setups that have worked for me are listed below, however they may vary depending on your needs: Windows Server-2019-English-Full-Base-2021.10.13 a. AMI Name: Windows Server-2019-English-Full-Base-2021.10.13 b. Instance Type: t2.2xlarge

Please review the needed network ports for inbound and outbound rules in your instance security group. To learn how to interact with security groups, consult this AWS documentation [5].
answered Mar 25, 2022 by Edureka
• 13,690 points

Related Questions In Others

0 votes
0 answers

How do I get data storage used on my AWS RDS?

I wish to know how much storage ...READ MORE

Apr 9, 2022 in Others by Kichu
• 19,040 points
410 views
0 votes
1 answer

Using SharePoint designer with SharePoint Online ?

Sharepoint gives you a trial account for ...READ MORE

answered Feb 12, 2019 in Others by Priyaj
• 58,020 points
665 views
0 votes
1 answer
0 votes
0 answers

Why can't I connect to AWS RDS?

0 I'm trying to connect to my new ...READ MORE

Mar 1, 2022 in Others by Edureka
• 13,690 points
605 views
0 votes
1 answer

AWS RDS MSSQL logs so many failed login attempts

Observing log files When you look at a ...READ MORE

answered Mar 25, 2022 in Others by Edureka
• 13,690 points
1,697 views
0 votes
1 answer

Amazon RDS - Online only when needed?

Here's a script that will stop/start/reboot an ...READ MORE

answered Mar 25, 2022 in Others by Edureka
• 13,690 points
636 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP