Forum

Notifications
Clear all

Trusted Data

23 Posts
2 Users
0 Reactions
289 Views
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Wow! Thank you so much. This is awesome.

I checked the result which you sent me and it is great.

I want to test other address but I can't use the file as I face this issue "Expression.Error: The import Table.FuzzyNestedJoin matches no exports. Did you miss a module reference?"

So I attached some images, please check it and let me know how I can solve it.

Deep thanks Catalin.

Thanks;

Marsil

 
Posted : 25/04/2021 10:37 am
(@catalinb)
Posts: 1937
Member Admin
 

Make sure first that your version of PQ has the fuzzy match function.

https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-the-import-xxx-matches/8335bba2-9c7b-47d8-a5d5-1ece1c9f9c4a

 
Posted : 25/04/2021 12:10 pm
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

You are right, I have to install latest version. I will ask my Administrator to apply this by coming Monday as we're on vacation
Please can you run attached address file to let me test it till I get latest version of power query.

Thanks;

Marsil

 
Posted : 25/04/2021 7:48 pm
(@catalinb)
Posts: 1937
Member Admin
 

here it is

 
Posted : 25/04/2021 11:22 pm
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Result is very good. thanks so much Catalin.

 IT team installed latest version of power query but I still face the same issue, I checked Google and I found some news about Fuzzy Matches with the Power Query is valid for office 360 subscribers only, is this correct? please confirm.

Thaks;

Marsil

 
Posted : 28/04/2021 6:53 pm
(@catalinb)
Posts: 1937
Member Admin
 

Yes, it's not available in standalone versions of office.

Go to Power BI desktop, the free version has all functions.

 
Posted : 28/04/2021 10:53 pm
(@marsil)
Posts: 72
Estimable Member
Topic starter
 

Hi Catalin,

Unfortunately, I couldn't create the same steps using Power BI desktop. please can help to create it.

I'm sure you are busy, when you have a chance please reply.  

Thank you very much; your support is greatly appreciated.

Thanks;

Marsil

 
Posted : 30/04/2021 9:26 am
(@catalinb)
Posts: 1937
Member Admin
 

You don't have to recreate the steps.
Just start a new project, connect to your Address.xlsx file with data, then go to Advanced Editor, just paste the entire query you have in the excel file and replace the source. All other steps are exactly the same.
Here it is

 
Posted : 30/04/2021 11:50 am
Page 2 / 2
Share: