Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 before my arrival there was a gateway constructed and installed in someone's computer. Is there a way to easily install a gateway in a virtual computer? (i'm definitly not an expert in this field so i would need some very simple explanation...)
On the other hand, when i use PowerBi Dataflow, i can reconstruct the databases and change connexion of the reports (manually) to connect to this dataset and republish them, the planned refresh seems to work in this case.
What would be better? Pass always through DataFlow o install a gateway somewhere? What are the pros and contras of the two techniques?
Thanks for your help in this topic!
Quentin
Solved! Go to Solution.
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.
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
Thanks for your answers, we are trying to develop this entreprise gateway in a virtual machine but as i'm just a powerBi administrator and not a global admin for the organization it doesn't rely on me enaymore therefore...
That's why i would have liked to pass by flow..
Thank you for your answers!
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.