I am trying to link Airtable and PowerBi. For the most part, it works perfectly. But, things are breaking down with the columns that link to another table. In such cases, I am getting recordID instead of Name. Is there a way to show record name instead of record ID? I have attached the Images from both AT and PBI for reference.
(I have gone through the solution that suggests creating a new column and using a formula to refer the linked column. For my case, it is not practical as there are around 20 linked columns)