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