PowerBI web with MySQL Gateway and Excel on Sharepoint is not working?

[danielvt]

Hi there,

I have setup a Reporting with different sources:

MySQL

MailChimp

Google Analytics

Excel Files on a Sharepoint folder

Within PowerBI desktop the refresh is working fine. For the web version I have setup a on-premises gateway for the mySQL
and added the App for MailChimp and Google Analytics but see refresh for the web version is not working.
I read that there are problems if you combine different sources at the web version. I also saw that after the upload the datasets are
all in one instead of 4 different datasets(for each source one dataset)

I have also found the following idea:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gatew...

Is there no workaround for this issue at the moment?

Best regards.

Daniel

[v-qiuyu-msft · Accepted solution]

Hi @danielvt,

You can enable Allow user's cloud data sources to refresh through this gateway cluster for on-premises data gateway, then you are able to set the dataset to use data gateway and edit credential for online data sources: https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

Best Regards,
Qiuyun Yu 

[danielvt]

Hi,

thanks for the reply. With the gateway in personal mode and the additonal option which you mentioned it is working now.
Is it planned to setup a possibility that reports with multiple sources will work with a gateway not in a personal mode?