Dataflow or DataSet with Gateways

hi  Quentin 

If the datasource is in on-premises, you need use an Enterprise Gateway to refresh for both dataset and dataflow.

Since power bi couldn't connect to on-premises data source, it needs Enterprise Gateway as bridge to get the on-premises data source.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem

So you'd better keep the Computer is always on to keeo the gateway is online.

In effect dataflows are an online data collection and storage tool.

• Collection:  It uses Power Query to connect to the data at the source and transform that data as needed.
  • You will need to be able to access the data either through a cloud service (such as Dynamics 365) or to your PC/Network via a gateway.
  • You can also use Power Query to write queries from scratch, such as my Power BI calendar table.
• Storage:  Dataflows then stores that data in a table in the cloud so it can be used directly inside PowerBI.com, but more importantly (from my view) directly from Power BI Desktop.

Then use power bi desktop to get data to import it and use it create a dataset.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview

https://radacad.com/what-are-the-use-cases-of-dataflow-for-you-in-power-bi

Regards,

Lin