Skip to main content

Airtable + PowerBI - Linked column showing up as recordID

  • May 24, 2019
  • 4 replies
  • 46 views
A
Forum|alt.badge.img+1

Hi,
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)

Thanks

4 replies

Justin_Barrett
Forum|alt.badge.img+21
  • Justin_Barrett
  • Inspiring
  • 4647 replies
  • May 25, 2019

How are you currently linking Airtable to PowerBi? I’m not familiar with the latter application, but my gut says that there’s got to be a way to extract the correct value from the linked records in Airtable so that they appear correctly in PowerBi.

B
Forum|alt.badge.img
  • Brian_Kinney
  • New Participant
  • 4 replies
  • May 26, 2019

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.

A
Forum|alt.badge.img+1
  • Abhijeet_Sharma
  • Author
  • New Participant
  • 1 reply
  • May 27, 2019

How are you currently linking Airtable to PowerBi? I’m not familiar with the latter application, but my gut says that there’s got to be a way to extract the correct value from the linked records in Airtable so that they appear correctly in PowerBi.


I am using Pagination query in PowerBI to link Airtable.

Justin_Barrett
Forum|alt.badge.img+21
  • Justin_Barrett
  • Inspiring
  • 4647 replies
  • May 27, 2019

I am using Pagination query in PowerBI to link Airtable.


As I said above, I don’t use PowerBi. A more detailed explanation of what a Pagination query does and how it operates would be helpful.


Terms & ConditionsAccessibility statement