01-01-2017 12:37 PM
jeppesal is right.
If there are connection only to cloud / online services - it doesn't make any sense to install a Gateway.
Guys, common, you can do better - please make the refresh stable - currently all Power BI projects are NO GO because of this.
01-02-2017 09:52 PM
Has anyone figured out how to use the on-premises gateway instead of the personal gateway to schedule synchronisation of web data sources?
I'm fed up with my scheduled sync failing due to my personal gateway (running on my laptop) being unavailable (i.e. my computer being turned off) just to pull data from a website into PBI online...
01-03-2017 01:19 AM
I had the same problem and the response from Microsoft was to vote for that feature (see http://community.powerbi.com/t5/Integrations-with-Files-and/On-premises-data-gateway-OData-OAuth2/m-...).
In short, the Gateway takes over all sources on-prem AND online BUT at the movement this is not supported, so you must add the Personal Gateway to enable the combination of on-prem and online sources.
Response from Microsoft
"In addition, I mean that your issue is caused by that on-premises gateway doesn't allow to combine on-premises data source and online data source in a single dataset."
This is such a crazy architecture and doesn't make any sense;
- First, why does the Gateway take over all sources and not just the on-prem sources?
- Why can I add online sources to the Data Gateway (manage gateways) if this feature is not supported?
- And even if the Data Gateway did support online sources, why are the connectors and authentication options limited compared to Power BI Desktop?
I hope Microsoft will rethink the backend architecture - at the movement it is too unstable and too confusing
01-04-2017 11:21 AM
@tomislav1975, we have changes to using the web.page function. Where a gateway is required if you are using it in a new published report. So in your case, you can either set up a personal gateway or add the data source to your enterprise gateway as a web datasource so you can use it.
01-19-2017 08:57 AM
@dimazaid Thansk Dima, its working now. But unable to schedule refersh for the report. it is saying it is "connecting directly" and and is asking for "windows" credentials. But since it is SP onprem, shouldnt it use a gateway?
How do i set up refersh using a gateway?