Forum Discussion
Solved
Power BI Web Service + Redshift Cluster in VPC
Hello, I am a solution architect assisting a client with Power BI running on top of their Redshift DW. They have Power BI Pro licensing, and are currently using the desktop client as well as the ...
- I am busy running a POC importing data from Redshift into AAS and using the Power BI Gateway where VM is in the VPC and it is working perfectly.
Hi there
When you are accessing the data are you importing it into the PBIX or going via DirectQuery?
When you are accessing the data are you importing it into the PBIX or going via DirectQuery?
All data access is using DirectQuery. The intention is to have access to near real time data.
- Hi there
From my understanding you would need to install and configure the Gateway VM to be in the same VPC as the Redshift cluster, that should then work?Absolutely, that is our intention. I just wanted to also make sure that as long as that's done they will also be able to login to the web service from outside their core network and still properly access the data.
My experience says that it should work, however I'm just looking for a sanity check.
- I am busy running a POC importing data from Redshift into AAS and using the Power BI Gateway where VM is in the VPC and it is working perfectly.