HomeWinBuzzer NewsMicrosoft Leverages OpenAI GPT-3 for New Power Fx AI Solution

Microsoft Leverages OpenAI GPT-3 for New Power Fx AI Solution

Power Fx can now translate natural language queries into code thanks to Microsoft’s exclusive OpenAI GPT-3 license.


is one of the leaders in artificial intelligence (AI) development. For every breakthrough research the company announces, the ultimate goal is to fold AI solutions into existing Microsoft services. For example, just like a new AI feature making its way to the Microsoft Power Platform.

According to Market.us, the Global Artificial Intelligence Market is estimated to reach USD 2967.51 billion from 2023 to 2032, it growing at a CAGR of 36.8%.

Specifically, a new assistive AI for will help convert natural language into workable code. It works exclusively with the Power Fx app in PowerApps and gives users the ability to implement AI tools without have a knowledge of high-level code.

As reported by The Verge, this is the first example of Microsoft using the GPT-3 language it licensed last year.

Microsoft furthered its relationship with OpenAI by exclusively licensing the artificial intelligence company's GPT-3 (Generative Pretrained Transformer 3). This is an autoregressive language model that is seen as a game changing technology. The exclusive licensing of GPT-3 drew criticism, most notably from Tesla CEO and OpenAI co-founder Elon Musk.

If you are not familiar with Power Fx, it is a language that is based on Microsoft Excel formulas. While it is not as flexible as popular languages like , it is easier to learn and use.

With the new natural language to code features, Microsoft is further mainstreaming coding for PowerApps customers:

“There's massive demand for digital solutions but not enough coders out there. There's a million-developer shortfall in the US alone,” Charles Lamanna, CVP of Microsoft's Low Code Application Platform, tells The Verge. “So instead of making the world learn how to code, why don't we make development environments speak the language of a normal human?”

How it Works

In a demonstration of the technology, Lamanna shows how it works in an application developer by Coca-Cola to track supplies. Users can drag and drop app elements like a PowerPoint presentation without needing to understand coding for moving those elements. While there are no code parts of the feature, some coding is needed for menus of specific database actions:

“This is when it goes from no code to low code,” says Lamanna. “You go from drag and drop, click click click, to writing formulas. And that quickly becomes complex.”

However, the new AI feature adds a new elements to Power Fx. When developers encounter database queries that are low code, they can now write out the query in natural langaue. OpenAI's GPT-3 then works to transcribe the natural language to functional code.

Microsoft is talking this up as a real gaming changing development in AI:

“I remember when we got the first prototype working on a Friday night, I used it, and I was like ‘oh my god, this is creepy good,'” says Lamanna. “I haven't felt this way using technology for a long, long time.”

Tip of the day: Tired of 's default notification and other system sounds? In our tutorial we show you how to change windows sounds or turn off system sounds entirely.

Last Updated on February 23, 2023 1:47 pm CET

SourceThe Verge
Luke Jones
Luke Jones
Luke has been writing about all things tech for more than five years. He is following Microsoft closely to bring you the latest news about Windows, Office, Azure, Skype, HoloLens and all the rest of their products.

Recent News