Forum Discussion
Post ProdigyOne PowerBI Service with sources in Multiple AWS Environments different Regions
Good day, I need help, please.
I have existing PBI service reports using a gateway to an AWS (Region Ireland) data lake.
I have a scenario where I need to migrate to a new AWS account but keep the existing/legacy account reports active too.
AWS Env1 = Legacy Account, (Ireland), Data Lake
AWS Env2 = New Account, (Virginia), RDS MS-SQL
1. Can my 1 PBI service have reports from 2 different AWS environments, regions & accounts?
2. Would i require another gateway for Env2 and would the PBI service work/recognize there's 2 gateways?
3. Does Env2/New require its own gateway on an EC2?
Kindly advise whats the best practise method, i dont want to setup Env2 and PBI service does not allow multi AWS Env with different Regions Gateways(2)
Thank You
Hey icassiem ,
Power BI is in one region: PBIRegion
All data is coming from two AWS regions: AWSR1 and AWSR2
I'm pretty sure you have to pay AWS if data is leaving the AWS data center to enter Power BI. Look for AWS egress costs
There is this one law, one dataset one gateway.
You might consider creating a dataset that combines the datasets into a "composite" model: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#building-a-composite-model-on-a-dataset-or-model?WT.mc_id=DP-MVP-5003068
Hopefully, this provides the needed information.Regards,
Tom
7 Replies
- TomMartens
Super User
Hey icassiem ,
here are some laws regarding datasets/gateways/regions ...
- one dataset can leverage data from multiple data sources (no matter the location of the data source)
- all data sources "feeding" one dataset MUST use the same gateway
- for performance reasons it's recommended to have the gateway as close as possible to the data source
If one of your datasets is leveraging data from both of your AWS regions you MUST use one gateway.
Nevertheless, it's possible to create two gateway connections to the same data source but using two different gateways if you have different datasets.
Hopefully, this helps to tackle your challenge.
Regards,
Tom
icassiemThank You Very Much
Currently, on Env1, 20 reports = 20 datasets of which i want to split across Env1 & 2Env1 = Legacy Data Feed
Env2 = New data feed
Basically i am good to split the datasets across two Env using a Gateway for each,
With a report = 1 dataset = 1 Gateway (regradless of region/account)?
- icassiem
I have just been questioned, there are a few reports that require the combination of regions/gateways are there ways around to handle the few report's scenario?
- icassiem
Hi,
With One PowerBI Tenant residing in 1 region,
with multiple gateways across other AWS Regions would PBI work being in a different tenant?
Regards