I can’t think of a better, easy-to-build-with database tool than Airtable, and flowing data from it for data visualisation in Power BI is a sweet marriage.
I’m not a coder, so I needed some step by step instructions, and you might too.
Here’s what I have found worked for me. Feel free to leave comments in the document, and if you want to collaborate and edit it, send me an email and I will add you as a collaborator.