Both personal and enterprise gateway

[Michieldo]

Hi there,

Currently I have installed the enterprise gateway and have several datasources (mostly MS SQL) running on the gateway cluster. Unfortunately Google Analytics is not supported by the enterprise gateway. However, I would like to combine these datasets. Previously I had the MS SQL running on the personal gateway too, but changed recently due to another problem and it seems that I can't use the personal gateway when this MS SQL is already added to a cluster?

Is there a way to resolve this issue without removing my enterprise gateway again?

Thanks!

[collinq]

Hi @Michieldo ,

Maybe I don't fully understand your issue.  But, the type of gateway is not about the data.  A personal gateway is Power BI only and is used by you.  An Enterprise means more folks, and particularly, the service in general, can use the gateway.  Here is an article about this:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode and perhaps this one:  https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-deployment-guidance

There are differences in the capability between the two, such as connection types, monitoring and other considerations.

Where you might be having technical problems is if the Enterprise and Personal gateways are on the same computer/server.

Other than that, you can have a Personal Gateway that is being used with SQL and and Enterprise Gateway that is using the same SQL.  It would be wise to make sure the corresponding reports are not refreshing at the same moment (for overhead reasons).    

You can have a report hit different data sources (SQL, Excel, SharePoint, a different SQL, etc.).  This createst the dataset.

For a report/dashboard to use multiple datasets you will have to use that dataset in the Service.  Most commonly, folks will publish the two separate reports from different datasets and then combine them in the dashboard.

You can also use Dataflows now that might be of assistance.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[Michieldo]

@collinq Thanks a lot, very clear!

The problem is that I have to use enterprise gateway as well as the personal gateway (necessary for R-script and Google Analytics) within the same report. Combining them in the dashboard is not possible since I have to combine them in an earlier stage in Power Desktop to get the right measures and merges in M code. So the only option is to use dataflows?

I hoped there would be a solution that would allow me to use both personal and entreprise gateway within the same report.