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!
Did I answer your question? Mark my post as a solution! Proud to be a Datanaut!
Private message me for consulting or training needs.
