Fuzzy Merge not refreshing with On-premises data gateway
Getting the above error when trying to refresh my report using the fuzzy merge preview feature (New with October release.) Have updated On-premises data gateway to October's release. Refreshes fine on desktop. Any ideas?
10 Comments
- Mallev
Advocate I
I have exaclty the same issue. Works fine on desktop but fails the refresh.
Also updated the gateway to latest version.
Only solution I have is to disable the new fuzzy lookup table for now.
- v-qiuyu-msft
Community Support
Hi AnonymousMallev,
I have reported this issue internally: CRI 89715905. Will update here once I get any information.
Best Regards,
Qiuyun Yu - v-qiuyu-msft
Community Support
Hi all,
I got information below:
"Fuzzy Matching" is only supported in Power BI desktop since October release. There is no ETA when this feature will be supported on Power BI service or On-Prem Data Gateway.
Best Regards,
Qiuyun Yu - Mallev
Advocate I
Thats a real shame.
I guess you should update the blog post that says this is supported in the October release.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-2018-feature-summary/
"Please note that in order to be able to refresh datasets that leverage this feature in the Power BI service, you will need to upgrade to the October release of the On-premises data gateway."
Thanks for the feedback.
- v-qiuyu-msft
Community Support
Hi Mallev,
Thank you for your suggestion. I have delivered it internally, will update here if I get any response.
Best Regards,
Qiuyun Yu - AnonymousNot applicable
I am having the same issue. This is a real bottleneck. The fuzzy merge feature works great but I have to refresh data sets on a regular basis. Please fix soon. For now, I have been re-publishing my dataset manually and updating the app so my SharePoint users can see this data. Thanks!
- v-qiuyu-msft
Community Support
Mallev The feedback already delivered to PM team.
Anonymous As mentioned previously, there is no ETA when will fuzzy merge supported on Power BI service. You can keep an eye on this article to see updated features on Power BI service: https://docs.microsoft.com/en-us/power-bi/service-whats-new
Best Regards,
Qiuyun Yu - AnonymousNot applicable
Is there any update on this? Having to update dashboards via the desktop app is proving to be time costly for our company.
- AnonymousNot applicable
I experience exact the same issue with fuzzy match with the same error description.
- AnonymousNot applicable
Almost 2 years later, this issue still seems to be here, any work around other than removing the fuzzy matching