Help

Re: Linking multiple Airtable tables to PowerBI

274 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Van_P
4 - Data Explorer
4 - Data Explorer

Hi,

following these instructions Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support I was able to link a single Airtable table to PowerBI and this works very well. However, I would like to link multiple tables from the same Base to PowerBI. Does anyone know how to solve this?

Cheers!

11 Replies 11
Davidt
6 - Interface Innovator
6 - Interface Innovator

I actually was trying out accessing the data via postman and surprisingly, also there I had authentication problems. So it seemed i'm getting something wrong, unrelated to powerbi...aaaaaaaaaand i found another post on the community forum that actually saved me: I was using the token snippet instead of the full token, just as this other user did. I know, sounds stupid, and it is 😄 Thanks @HansZenth_Work for your help! 

Multiple tables from airtable in powerbi now. Nice. Is it normal that a mere 1500 rows will take like 3 minutes to load? And as a Powerbi beginner i don't know this: How can I stop powerbi from pulling new data every time i transform something in powerquery? I don't really want the data to be pulled anew into memory from airtable every time I apply a filter or something...is this possible?

Hans I have not been able to find how to show the values in linked record fields as the just show list. I assume you

1. pull in the linked tables

2. extract the list which appears to be the airtable record ID

3. merge the queries by this ID 

4. expand the linked record column. 

Is this the only way? If not is it the most efficient way?