Forum Discussion
Do I need a gateway?
An on-premises data source is data that is kept on local (or restricted Cloud) infrastructure. This would include your local machine, any local servers at your company, or VMs that are restricted behind a firewall.
Cloud data sources are ones that are hosted on a public cloud, such as Azure. This includes Azure SQL, Sharepoint Online, and many other online services.
In your situation:
1) If this is the Sharepoint Online that comes with Office 365, then it's a cloud source. You don't need a data gateway. If it's run by your company's IT team on your own infrastructure, you will need a data gateway.
2) This depends on where the data for "despro" is stored. If it's a database stored on your local machine, or on a local server, then you need a data gateway.3) Any local files, whether they are on a virtual machine or your local desktop, will require a data gateway.
Hi pranim,
malagari's explanation is good. Just want to add additional information. :)
1. If the Excel get data from a on-premise data source, eg: SQL Server database. Though the Excel stored in SharePoint online, after import data into Power BI, you need also to use gateway. OneDrive Refresh is turned ON by default. You can also set schedule refresh based on your needs. See: Refresh a dataset created from an Excel workbook on OneDrive, or SharePoint Online.
2. As we are not aware of your internal tool, you can take a look at those two articles, you will know if you need gateway in your scenario:
3. As long as the Excel in local drive, gateway is required.
Best Regards,
Qiuyun Yu
An on-premises data source is data that is kept on local (or restricted Cloud) infrastructure. This would include your local machine, any local servers at your company, or VMs that are restricted behind a firewall.
Cloud data sources are ones that are hosted on a public cloud, such as Azure. This includes Azure SQL, Sharepoint Online, and many other online services.
In your situation:
1) If this is the Sharepoint Online that comes with Office 365, then it's a cloud source. You don't need a data gateway. If it's run by your company's IT team on your own infrastructure, you will need a data gateway.
2) This depends on where the data for "despro" is stored. If it's a database stored on your local machine, or on a local server, then you need a data gateway.
3) Any local files, whether they are on a virtual machine or your local desktop, will require a data gateway.
My terminal data source is an Azure SQL DB, but it's consumed by my PBI reports through OData API. Do I need a gateway? Thanks!