Using OpenAI and Azure OpenAI functions in Power BI dataflows

Your next step is to prep the FAA Wildlife Strike data for the OpenAI or Azure OpenAI functions to do content generation and summarization. As discussed previously, you’ll need to build effective prompts to provide context for the OpenAI models to process. The completed query for Reports Curated New OpenAI, which can be copied and pasted into Power BI, is also available from the Packt GitHub repository: https://github.com/PacktPublishing/Unleashing-Your-Data-with-Power-BI-Machine-Learning-and-OpenAI/tree/main/Chapter-13.

Looking back to Chapter 12, you decided upon the following combinations of new text with row-level content from the FAA Wildlife Strike database:

• Generating new information about airplanes and the carriers: Tell me about the airplane model [Aircraft] operated by [Operator] in three sentences:
• Summarizing the remarks from each report, including the operator, aircraft, and species: Summarize...