Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How would you begin to diagnose a unexpected error when you are trying to connect to a databse which is not on premise
I understand you don't require a gateway if the source is not on-premise (i understand its in AWS again not ours another business we are working with). We can connect to this source fine within Power BI Desktop/Power Query
The source is requesting a IP Address (seems thay are using IP whitelisting) to restrict. As dataflows is in the service exactly what IP address would they be refering to??
I've had a look in this document Download Azure IP Ranges and Service Tags – Public Cloud from Official Microsoft Download Center
and given the IP address for PowerQueryOnline. UK South but that hasnt solved the problem
Hey @Anonymous ,
with AWS and Power BI Service it's a little bit more complicated
Did you set the AWS environment up, like described by Amazon with VPC, Subnet and Gateway?
Check the following chapter in the whitepaper on how to do that:
Using Microsoft Power BI with the AWS Cloud - AWS Whitepaper (amazon.com)
Then it should work with AWS.
Thanks Denis
The AWS instance was not set up by us. I gave the Amazon Redshift a go it it stated invaild credentials (which is better than a unexpected error)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.