Forum Discussion

dimazaid's avatar
dimazaid
Microsoft Employee
9 years ago

Updates to the Web connector

We are currently working on improving the refresh of cloud based data sources. As part of this, one of the changes we have made recently is that new datasets that leverage import from Web pages will ...
Announcement
General Comment
matmoore's avatar
matmoore
Frequent Visitor
9 years ago

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...

jeppesal's avatar
jeppesal
Advocate II
9 years ago

Hi Matmoore,

 

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-p/101069#M7093).

 

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;

  1. First, why does the Gateway take over all sources and not just the on-prem sources?
  2. Why can I add online sources to the Data Gateway (manage gateways) if this feature is not supported?
  3. 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 :(