Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
danielvt
Advocate I
Advocate I

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

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

1 ACCEPTED SOLUTION
v-qiuyu-msft
Community Support
Community Support

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 Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
ReportGuru
Helper V
Helper V

Hi @danielvt As a workaround, I think you can connect both Mailchimp and Google Analytics data to MySql and therefore you'll be pulling data from only 1 data source. I think this will solve the issue when refreshing at the web version. I connect many data sources to MySql using windsor.ai and from then I just directly connect it to Power BI

v-qiuyu-msft
Community Support
Community Support

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 Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.