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)
A good data integration from Airtable to a BI tool should transfer the recordIds of all your Airtable records so that you can join records according to these recordIds. This should enable you to look up any of the fields of linked records. If your Airtable -> PBI data integration does not support this you should find a different method.