Excel and Power Query table, hyperlinks set as text

[bluesky61]

Hello everyone,

I did several research and I couldn't find my case.
I have a workbook with 5 sheets, all contain a table (BDDAccompagnateurs, BDDHôtels, BDDRestaurants, BDDTransports, BDDVisites)
I created a query on each of these tables

Query Dependencies.png

Then I created an append of this 5 querries with the formula = Table.Combine({BDDAccompagnateurs, BDDHôtels, BDDRestaurants, BDDTransports, BDDVisites})

My issue is that in my 5 original tables have a column named "Source" that contains different hyperlinks with the same text to display "Lien"

In another workbook that contain the append table the hyperlinks are formatted as Text and only show the word "Lien"
Link.PNG

How can I change this ? I don't see hyperlink as a choice in the format option of Power Querry.
However I see this in the formula of each table
source power querry.PNG

Thank you very much for your help

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

[bluesky61]

Dear AliGW

Thank your for your answer.
I have attached a simplified version of my files however there might have an issue with the querry on it.
The 5 tables are in BDD and the append on BDD Append.
There is the source in column M of the BDD workbook.

Thank you very much for your help,