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.
We have created an AWS RDS public facing SQL Server standard 2017 instance. I am able successfully connect to the database in Power BI Desktop using the Direct Query. I have created my charts and published them to the powerbi.com website.
When i try to view the charts on the PowerBI.com website, i get the error "there is no gateway to access the data source"
The AWS RDS is public facing with 0.0.0.0/0 and I entered the database credentials into the Power BI desktop tool, and it works correctly in the power bi desktop. However, it doesn't work on the PowerBi.com site.
I must use directquery, i can't use import
any help is appreciated
Solved! Go to Solution.
you need to install a power bi gateway in AWS that exposes that DB in AWS. The power bi service runs in Azure and the gateway is needed to access data sources in other clouds and on premises.
So, either you put your data in SQL Azure db (which is directly accessible thru power bi service) or provide the gateway. Those would be your 2 options.
you need to install a power bi gateway in AWS that exposes that DB in AWS. The power bi service runs in Azure and the gateway is needed to access data sources in other clouds and on premises.
So, either you put your data in SQL Azure db (which is directly accessible thru power bi service) or provide the gateway. Those would be your 2 options.
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.