Forum Discussion
Advocate IPowerBI web with MySQL Gateway and Excel on Sharepoint is not working?
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
Community SupportHi 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
Advocate IHi,
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?