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

Unable to create Azure Purview Account – Resource provider Microsoft.Purview is not registered

 In my last Azure Purview Quickstart video (#3 – Create an Azure Purview Account – link), I’ve shown you how to create a new Azure Purview account.

And what pre-prepared demos have in common, well – it “just” works there 
BUT: there are some requirements that need to be configured beforehand, in order to create an Azure Purview Account.

Basically, problems during the creation process can be listed to:

• Security / permissions
• Missing Resource providers

Permissions required to create an Azure Purview Account

You need Azure Contributor or Owner role (or be an Administrator of the Azure subscription)

Missing Resource providers

Azure Purview requires the following resource providers to be registered in your Azure subscription. If you have not heard of Azure resource providers before, please have a look at the docs page.

Azure Purview requires the resources providers for

• Microsoft.Purview
• Microsoft.Storage
• Microsoft.EventHub

to be activated in your subscription…

The validation error message looks similar to this one:

Validation failed with error: The template deployment ‘Microsoft.AzurePurviewGalleryPackage-datagov01’ is not valid according to the validation procedure. The tracking id is ‘xxxxxxxx’. See inner errors for details.
Detailed error(s):
21005 – The resource providers Microsoft.Storage and Microsoft.EventHub and Microsoft.Purview are not registered for subscription xxxxxx. For improved Azure Policy validation on managed resources, we recommend to register Microsoft.PolicyInsights resource provider on your subscription.

The resource providers Microsoft.Storage and Microsoft.EventHub and Microsoft.Purview are not registered for subscription xxxx

Missing resource providers (Microsoft.Purview) for Purview Account

How to register missing resource providers?

• First of all – you need administrative access to your Azure subscription to enable resource providers.

• Open the Azure portal and head over to Subscriptions

Azure subscription list

Select the Resource providers menu entry and search for the three required ones (Microsoft.Purview, Microsoft.Storage, Microsoft.EventHub)

Resource provider menu in the subscription section

(1) Search for the resource provider name, select (2) the entry and (3) register / re-register it in your subscription.

Resource provider details page

Reminder: check for all three resource providers to be registered! 

With these configuration steps, you now should be able to create your Azure Purview account!

20 Cloud based Virtual Sandbox or CloudPC or Remote Environment Tools available for no cost

1. Browserling – A cloud-based browser sandbox for securely running applications in an isolated virtual machine.

2. – A web-based virtual browser for secure browsing and testing without installation.

3. NetworkChuck Cloud Browser – A zero-trust browser isolation tool for secure browsing and malware testing.

4. Any.Run – An interactive malware analysis sandbox that runs in the cloud, allowing real-time testing of suspicious files.

5. – A cloud-based Windows PC that can be accessed remotely for testing and development.

6. RollApp – A cloud-based platform that lets you run desktop applications in a browser, including development tools.

7. DistroTest – A free online service that allows you to test various operating systems, including Windows alternatives, in a browser.

8. AppOnFly – A cloud-based Windows desktop that allows you to run applications remotely.

9. CloudShell – A browser-based cloud environment for running Linux and Windows applications securely.

10. Microsoft Azure Sandbox (Microsoft Learn) – Free, temporary Windows VMs via browser-based Azure Cloud Shell for testing VSCode projects or learning Azure.

11. – Open-source cloud sandbox with Windows VMs for dynamic malware analysis, suitable for testing VSCode project files.

12. VirusTotal – Free service for scanning files/URLs with antivirus engines, including Windows-based sandbox analysis for VSCode files.

13. Hybrid Analysis – Free cloud sandbox for static/dynamic analysis of files in Windows VMs, ideal for verifying VSCode project safety.

14. Kasm Workspaces – Browser-based Desktop-as-a-Service with free Windows desktops for testing and running VSCode in a cloud environment.

15. Google Cloud Free Tier (Compute Engine) – Free Windows VM (B1S instance) for 12 months via browser-based Google Cloud Console, suitable for VSCode development.

16. Oracle Cloud Free Tier – Forever-free Compute Instances with Windows support via browser-based Cloud Console, ideal for VSCode projects.

17. OnWorks – Free platform offering Windows virtual desktops via browser, suitable for running VSCode or testing Windows projects.

18. CodeSandbox – Cloud-based development platform with Windows-compatible environments via browser, optimized for VSCode-like web projects.

19. A few others open source projects activehttps://github.com/cuckoosandbox

    https://www.joesandbox.com/#windows

    https://testingbot.com/members/manual/new

    https://github.com/sandboxie-plus/Sandboxie

    https://capev2.readthedocs.io/en/latest/

Sandbox / Cloud VMS Related Services

Service	Description	User Rating	Price
Browserling	Online browser sandbox for secure browsing and testing.	Not widely rated	Paid
	Web-based virtual browser for anonymous browsing.	Mixed reviews	Paid
NetworkChuck Browser	Cloud-based secure browsing tool for OSINT and threat research.	Not widely rated	Paid
	Cloud gaming and virtual PC service for high-performance computing.	Well-rated	Paid
RollApp	Cloud-based application virtualization for running desktop apps online.	Mixed reviews	Paid
DistroTest	Online Linux distro testing without installation.	Well-rated	Free
AppOnFly	Cloud-based remote desktop service for running Windows apps.	Mixed reviews	Paid
Google Cloud Shell	Web-based command-line interface for managing Google Cloud resources.	Well-rated	Free
Microsoft Learn	Online training platform for Microsoft technologies.	Highly rated	Free
Google Cloud Free	Free-tier cloud services including compute and storage.	Highly rated	Free (limited)
Oracle Cloud Free	Free-tier cloud services with compute and database options.	Well-rated	Free (limited)
OnWorks	Free online virtual machines for Linux and Windows.	Mixed reviews	Free
CodeSandbox	Online collaborative coding environment for web development.	Highly rated	Free & Paid
TestingBot	Automated and manual browser testing platform.	Well-rated	Paid

Malware Related

Service	Description	User Rating	Price
ANY.RUN	Interactive malware analysis sandbox with real-time execution.	Highly rated	Free & Paid
	Malware analysis sandbox with automated threat detection.	Well-rated	Free & Paid
VirusTotal	Multi-engine malware scanning and threat intelligence platform.	Highly rated	Free
Hybrid Analysis	Deep malware analysis powered by Falcon Sandbox.	Well-rated	Free & Paid
Cuckoo Sandbox	Open-source automated malware analysis system.	Well-rated	Free
Joe Sandbox	Advanced malware analysis with deep behavioral insights.	Highly rated	Paid
CAPE Sandbox	Malware configuration and payload extraction sandbox.	Well-rated	Free