Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pranim
Helper I
Helper I

Do I need a gateway?

Hi,

 

Please help me 

 

I have two different datasets from different sources. ( I am working on two projects basically, to create dashboards) Can anyone explain me what is on- premises, External, live , direct query models?

 

1)I have  a dataset in sharepoint online excel sheet (is it on -premises, online or other)?  should i use a gateway to schedule refresh in power BI Service? or it gets refreshed automatically

 

2)Another data comes from a internal tool(despro)  - Should i  use gateway for this to schedule refresh in power BI?

 

3)what if i get data from excel sheet - is it local drive? do i need a gateway? 

 

Thanks in advance

 

2 ACCEPTED SOLUTIONS
malagari
Responsive Resident
Responsive Resident

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.

Dan Malagari
Consultant at Headspring

View solution in original post

v-qiuyu-msft
Community Support
Community Support

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:

On-premises data gateway

Power BI Gateway - Personal

 

3. As long as the Excel in local drive, gateway is required.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-qiuyu-msft
Community Support
Community Support

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:

On-premises data gateway

Power BI Gateway - Personal

 

3. As long as the Excel in local drive, gateway is required.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi ,

 

Suppose, if i am connected to Postgres, and pulling the data from it to power bi app,

 

How can i get it?

 as of now 

 

I have scheduled one PBI app on daily basis to run at 10:00 am after installing on premises Personal gateway it is working fine.

 

when my laptop is on always.

sometimes my app is getting failed when my laptop is off. Can you please guide how to avoid this error.

i want my app should work without any dependency.

how can we achieve it?

Hello. 
I have the same question. How can the report still work even if my laptop/machine off?

Thanks. 

malagari
Responsive Resident
Responsive Resident

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.

Dan Malagari
Consultant at Headspring

@malagari 

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! 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors