Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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:
Is there no workaround for this issue at the moment?
Best regards.
Daniel
Solved! Go to 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
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
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
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
27 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
38 | |
26 | |
24 | |
20 |