Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to load language - Issues with online refresh

Hello,   I have an online report (premium workspace) that has a scheduled refresh but is not working. Error message below   We're sorry, an error occurred during evaluation.;Unable to load langua...
Need Help
mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
4 years ago

After a delay of around 2 weeks, Microsoft Support have come up with an "alternate solution". They suggested to add a sub-parameter inside the record that makes up the 7th parameter of the Table.FuzzyNestedJoin function:

 

, [Culture="en-US"]

 

Although editing that in did get a successful refresh in a PPU workspace, I rejected it as a solution as:

  1. code edits should not be necessary for functionality that works in Power BI Desktop and Pro workspace refresh
  2. any edit to the Merge Query step using the PQ UI will remove the inserted code
  3. any new Merge Query step created using the PQ UI will trigger this issue

 

FWIW here's a variation of my repro with their "alternate solution" implemented:

https://1drv.ms/u/s!AmLFDsG7h6JPhvpRoFbNRpN286EHOQ?e=EqEAbL

PPU Fuzzy Match bug repro - locale workaround.pbix