Hello,
I am still trying to grasp some of the terminology, but I was tasked with loading some tables from Discourse into my Microsoft Fabric Lakehouse for reporting in Power BI. The approach I’m taking is to have a list of queries from data explorer and to use API post to get the data. From what I’ve read, the data queries is the most common approach but is there another way to just list table names and ingest full tables from Discourse?
I tested that I could create and use an API key with my user account since I am an admin and successfully get the tables returned. Is it possible to achieve this with an OAuth provider like Microsoft Entra ID instead of having to use my username in the header? The other option I was considering was a service principle account.
Thank you,
Rachel