Forum Discussion
Solved
Dataflow or DataSet with Gateways
Hello everyone, As new administrator in powerBI i have to understand the best technique for my organisation to automatically refresh the published reports we have. I can see that there was befo...
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
- Collection: It uses Power Query to connect to the data at the source and transform that data as needed.
Hi there
Firstly if your data is sitting on-prem then you would need an Enterprise Gateway installed. Ideally this should be installed on a Virtual Computer as you suggested.
With regards to datasets or dataflows they do different things.
A dataset is a complete data model with relationships and measures which other users can connect to to create reports.
A dataflow is data that has been shaped into the right format, but is basically just a data table. You will still have to import the dataflow into a dataset to create the dataset.
Firstly if your data is sitting on-prem then you would need an Enterprise Gateway installed. Ideally this should be installed on a Virtual Computer as you suggested.
With regards to datasets or dataflows they do different things.
A dataset is a complete data model with relationships and measures which other users can connect to to create reports.
A dataflow is data that has been shaped into the right format, but is basically just a data table. You will still have to import the dataflow into a dataset to create the dataset.