Forum Discussion
Nestedjoin with SQL server and Exchange kills both connections
Hi! I have run into a very irriating issue that I hope someone might be able to help me with. I have two data sources, exchange online where I download some mail and one sql server table. Both wo...
Hi Anonymous
It requires a on-premise gateway or on-premise(personal) gateway to merge or append on-premises and cloud data sources.
You need add the on-premise data sources as a data source under the on-premises gateway and give credential for web data source under the dataset setting in Power BI Service.
Do you download a on-premises gateway and configure as below?
install a gateway for Power BI
Manage a gateway and configure schedule refresh
merge or append on-premises and cloud data sources
Best Regards
Maggie