Hi @mario_lamban Strange. The solution proposed is totally agnostic to the first record {0}It runs over all records and extracts the distinct list of field names from all records.Maybe the fields you expect to show on the BI are empty on all records ...
Just a guess - due to the change you may experience also a permissions change which results with records not being returned and then null value instead.
Hi Everyone,After some research + a lot of trial and error, here is a solution.No need for dummy row or any other change at AT.Replace this #"Expanded Record Fields" = Table.ExpandRecordColumn(
#"Reordered Columns", "_airtableRecordFields",
...
+1 for linking tables across different bases.
As noted by other people, higher granularity permissions and even aggregation + hiding of tables tab won’t resolve the need.
Collapsing all company’s bases into one means over loaded base which would serv...