Forum Discussion
Post ProdigyOne PowerBI Service with sources in Multiple AWS Environments different Regions
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
Super UserHey 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)?