Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We face an issue with a query using SAP BW Properties (november feature). For that particular query the refresh with on-premise gateway failed with the following error. Others reports using this functionnality work well. In the desktop, refresh is also ok with that report. Any idea ?
Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.
Solved! Go to Solution.
Hi @Anonymous,
Does the report only contain one data source (SAP BW)? Please check which action do you perform for Table: Master Data - Client Regions? How about remove issued Table: Master Data - Client Regions temporarily then republish to service to refresh again? Please back up original pbix file in advance.
Please export gateway logs and share with us: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting
By the way, please try to update the on-premise data gateway to the latest version as well.
Best Regards,
Qiuyun Yu
Hello,
Thanks for the reply, yes it does contain only one datasource among manual entered data.
We did try to remove the failing query and the problem was gone.
After that we update the gateway to october version and it did solve the entire problem. We were still in a previous version (july by memory) whom seem to be incompatible with new SAP BW Properties features :
Thanks again for your help
Regards.
Hi @Anonymous,
It seems the issue is resolved now, right?
Best Regards,
Qiuyun Yu
Hello,
Thanks for the reply, yes it does contain only one datasource among manual entered data.
We did try to remove the failing query and the problem was gone.
After that we update the gateway to october version and it did solve the entire problem. We were still in a previous version (july by memory) whom seem to be incompatible with new SAP BW Properties features :
Thanks again for your help
Regards.
Hi @Anonymous,
Does the report only contain one data source (SAP BW)? Please check which action do you perform for Table: Master Data - Client Regions? How about remove issued Table: Master Data - Client Regions temporarily then republish to service to refresh again? Please back up original pbix file in advance.
Please export gateway logs and share with us: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting
By the way, please try to update the on-premise data gateway to the latest version as well.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.