One PowerBI Service with sources in Multiple AWS Environments different Regions

[icassiem]

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

[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

[TomMartens]

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

[icassiem]

Thank You Very Much
Currently, on Env1, 20 reports = 20 datasets of which i want to split across Env1 & 2

Env1 = 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]

Any Update Please?

[TomMartens · Accepted solution]

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-compo...

Hopefully, this provides the needed information.

Regards,

Tom

[icassiem]

Thank You so much @TomMartens  

🙏Much Appreciated