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.
Hi all, We are moving to a Microsoft 365 E5 plan and I'm looking to bring Power BI Pro into our organization (because it's included with E5), but I'm running into issues connecting to RDS Postgres on AWS. I created a report using the desktop app and shared it to my workspace. I then went to app.powerbi.com to view the report and the dataset will not work. The error I see is:
Failed to update data source credentials: PostgreSQL: We were unable to find a database provider with invariant name 'Npgsql'.
I'm assuming there's no way to install that in the online application. Is there another way to connect to AWS RDS instances? Does Pro offer anything different? Also how will I go about letting the Power BI service through the RDS security group? I didn't find Power BI service IP addresses and the other posts that I found suggest that they may change weekly anyways.
Most of our data lives in AWS. I'm wondering if Power BI will be a good fit for us.
Solved! Go to Solution.
We This doesn't seem to work. We have gateway installed on the same machine where also PBI Desktop is installed (latest version with npgsql package), and both manual or scheduled refreshes don't work with the same error about missing npgsql package.
Looks like it's missing somewhere on the MS hosts in the cloud
This is what I just did:
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.