Forum Discussion

marcorusso's avatar
marcorusso
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago
Solved

Connect directly does not appear for Google Analytics

I have a PBIX file that connects to Google Analytics and gets data from a web page. Once I publish the PBIX on powerbi.com, the refresh requires a personal gateway, not using the entrprise one and n...
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi marcorusso

     

    From my understanding there currently is a limitation on the On-Premise (Enterprise) gateway, where currently all the data has to come from one source, with that either being all cloud or all on-premise.

     

    If your PBIX has data that is combined from say Cloud or On-Premise (Where the Google Analytics Connector is sources from Get Data, which is considered On-Premise) then your current option is to only use the Personal Gateway.

     

    With that being said the Power BI Team are working on combining the two different sources using the On-Premise Gateway, but as you can see below the first release is scheduled for the end of September with a limitation being that it will not be able to Mash-Up data between the different data sources.

     

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources?tracking_code=9a3916fc201e4f6a55318148ccda05f6

     

    So currently what I have been doing with Customers to use the Personal Gateway installed on a server until such time the On-Premise Gateway has the new features.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

Can you clarify, you say that the only option is available for Data Refesh is the Personal Gateway but that you can't use the on-premises one. But the Personal Gateway is on-premises, so ?

 

That being said, there are definitely combinations of data sources that are problematic to automatically refresh. Generally when you run into those issues, the Personal Mode of the Data Gateway resolves most of those issues.

  • marcorusso's avatar
    marcorusso
    Icon for Most Valuable Professional rankMost Valuable Professional
    9 years ago

    I know, but the Personal Gateway does not guarantee it's always on, for this reason I would like to use the on-premises data gateway installed on a server available 24x7.