Based on an earlier post on connecting airtable data to Power BI, some folks, including me, have problems reading Airtable fields/columns that have blank/missing values for some records. Based on an note from a user in the early post, I am able to re...
let Pagination = List.Skip( List.Generate( () => [Page_Key = "init", Counter=0], // Start Value
each [Page_Key] <> null, // Condition under which the next execution will happen
each [
Page_Key = try if [Counter]<1 then ""
else
[WebC...
Can you elaborate a little about where to insert the code?Here is M Query code from the Airtable Support site.let Pagination = List.Skip( List.Generate( () => [Page_Key = "init", Counter=0], // Start Value
each [Page_Key] <> null, // Condition unde...
+1 for this feature request. We also have a long list of numbers for people to select from and it would be advantageous in our form to have a read-only view of the lookup that is a description of that number that they choose. We would use this as a...
