Languages used in Power BI, Power Automate, Power Apps, and Dataverse, along with summaries, usage, examples, and links to their respective API

Power BI

Language	Summary	Code Example	LanguageUsedIn	Docs
DAX	Formula language for calculated columns, measures, and tables.	Total Sales = SUM(Sales[Amount])	Measures, Calculated Columns, Calculated Tables, Row-Level Security	DAX Reference
M (Power Query)	Functional language for data transformation in Power Query Editor.	= Table.SelectRows(Sales, each [Amount] > 1000)	Power Query Editor, Data Source Queries, Query Parameters	M Language Reference
R / Python	Used for advanced analytics and custom visuals.	summary(lm(Sales ~ Region, data=sales_data)) (R)	Power BI Desktop Scripts, Custom Visuals, Transform Data Scripts	R & Python in Power BI

---

Power Automate

Language	Summary	Code Example	LanguageUsedIn	Docs
Workflow Definition Language (WDL)	JSON-based schema for defining flow logic and expressions.	@equals(triggerBody()?['Status'], 'Approved')	Conditions, Expressions, Dynamic Content, Advanced Mode in Actions	WDL Overview
Power Fx	Low-code formula language used in some expressions and integrations.	If(Status = "Approved", "Proceed", "Hold")	Instant Plugins, Dataverse Accelerator, Desktop Flows (Preview)	Power Fx in Power Automate

---

Power Apps

Language	Summary	Code Example	LanguageUsedIn	Docs
Power Fx	Excel-like formula language for app logic and UI behavior.	If(User().Email = "admin@contoso.com", Navigate(AdminScreen), Navigate(HomeScreen))	Canvas Apps, Cards, Formula Columns, Model-Driven Command Bars, Instant Plugins	Power Fx Docs
JSON / REST APIs	Used for external data integration via custom connectors.	Patch(MyDataSource, Defaults(MyDataSource), {Name: "Jason"})	Custom Connectors, HTTP Actions via Power Automate, REST API Bindings	Power Apps REST APIs

---

Dataverse

Language	Summary	Code Example	LanguageUsedIn	Docs
OData / Web API (REST)	HTTP-based API for CRUD operations on Dataverse data.	GET https://<org>.crm.dynamics.com/api/data/v9.2/accounts	External Integrations, Custom Connectors, Power BI Direct Query, Power Apps REST Calls	Dataverse Web API
C# (via SDK)	Used in plugins, custom workflows, and server-side logic.	service.Create(new Account { Name = "Contoso" });	Plugins, Custom Workflow Activities, Azure Functions, Server-Side Extensions	Dataverse SDK

---

Would you like this exported as a CSV or markdown file for quick reference? Or maybe a visual map showing how these languages interact across the platform? I can whip that up too. Let me know how deep you want to go