Two data sources (one of which is Google Analytics) in one dataset, auto refresh not working

[gsxr]

Hi,

I am trying to configure auto refresh for a dataset that has two data sources in Power BI service but it is not working properly. The two data sources are:

(1) Some on-prem sql tables fed into a dataflow using a gateway set up by IT

(2) A google analytics table fed into a dataflow using my own credentials (because Power BI and Google Analytics does not have a good gateway together so I had to use personal account connection)

Both dataflows themselves are auto refreshing fine independently with the different credentials. However, recently I needed to get this info from the two dataflows into the same dataset for cross reference reporting. When i put them together, they refresh fine on Power BI desktop. When I upload this dataset to Power BI service, the settings part still defaults me to the gateway in (1), but complains for the authentication of Google Analytics as mentioned in (2). 

I am not sure if multiple credentials in one dataset is currently not supported in Power BI service. Any answers and suggestions are deeply appreciated!

[GilbertQ]

Hi @gsxr 

You can actually just use Google Analytics within the Power BI Service without a gateway. You just need to edit your credentials and off you go.

I am using it daily and it is configured as shown below.

[gsxr]

Thank you, but it appears from some other posts that Google Analytics is not supported in Power BI gateways? Thank you for any suggestions. 

https://community.powerbi.com/t5/Service/Google-Analytics-Cannot-be-Added-to-Gateway/m-p/1533171

[GilbertQ]

Hi @gsxr 

As far as I know you would need to have both data sources on the same gateway?

I would ask IT to set up the Google Analytics on Gateway 1

[gsxr]

I'm pulling this into a dataflow and yes, gateways are not required for google analytics on its own. The dataflow as mentioned in original post (2) is set up as follows and runs great on it's own:

However the issue is that in my case I also need to bring in data from other sources as mentioned in original post (1). Power BI service does not recognize two sources with two different credentials (SQL gateway and google analytics personal auth), and gives me a refresh error. As written in the original post, I had to pull two separate dataflows into one dataset. Thanks for any advice.