Forum Discussion
Different sources at different servers
Hi Xavi_Mora
Your understanding is correct.
multiple enterprise gateway on one dataset
Based on my understanding, to refresh a dataset with mutiple data sources in different servers
One way is:
Import mutiple data sources as a single dataset with Power BI Desktop,
Install on-premises gateway in the server which can access to those different servers,
Add data sources under this gateway when configuring schedule refresh.
Another way is like yours:
backup every SQL/other formats in one server and build the "big" report from these backups,
or use Azure DB to store data online, then connect to this Azure DB with Power BI.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Xavi_Mora
Your understanding is correct.
multiple enterprise gateway on one dataset
Based on my understanding, to refresh a dataset with mutiple data sources in different servers
One way is:
Import mutiple data sources as a single dataset with Power BI Desktop,
Install on-premises gateway in the server which can access to those different servers,
Add data sources under this gateway when configuring schedule refresh.
Another way is like yours:
backup every SQL/other formats in one server and build the "big" report from these backups,
or use Azure DB to store data online, then connect to this Azure DB with Power BI.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many thanks Maggie!
I cannot make the servers see each other so I'll keep with the backups plan. It's been really helpful.
Thanks again! :D