Microsoft Power platform - Behind the Scenes
Programming Language: The underlying technology for Microsoft Power Platform, including Power BI and Power Apps, is a combination of various programming languages and platforms.
Power BI uses DAX (Data Analysis Expressions) for its data modeling and calculation functionality, and M for its data transformation functionality. DAX is a formula language that is used for creating custom calculations and measures in Power BI. M is a functional language that is used to perform complex data transformations in Power BI.
Power Apps, on the other hand, uses a proprietary platform and language for building custom applications and automating business processes. The platform provides a low-code/no-code development environment for building applications and automating workflows. It supports the creation of custom forms, custom connectors, and custom logic through a visual interface, and the ability to use JavaScript and Microsoft Power Automate to add custom code when needed.
Database :Microsoft Power Platform, including Power BI and Power Apps, supports multiple databases as a data source. The database you choose as a data source will depend on your specific needs and requirements.
For example, Power BI supports a wide variety of databases, including:
- SQL Server
- Azure SQL Database
- Oracle
- MySQL
- PostgreSQL
- Snowflake
- and many others.
In addition to these traditional databases, Power BI also supports data sources such as Excel spreadsheets, CSV files, SharePoint lists, and many others.
Similarly, Power Apps also supports a wide variety of databases, including:
- SQL Server
- Azure SQL Database
- SharePoint lists
- and many others.
The data sources that Power Apps supports will depend on the specific connector that you use, and the platform provides a variety of built-in connectors that allow you to connect to a wide range of databases and other data sources.
Power BI — Microsoft Power BI was developed using a combination of programming languages, including DAX (Data Analysis Expressions) and M.
DAX is a formula language used for creating custom calculations and measures in Power BI. It is used to create expressions that manipulate data in a Power BI data model, and it is designed to be easy to use and understand, even for users without a strong background in programming.
M is a functional language used for data transformations in Power BI. It provides a powerful way to perform complex data transformations, and it is used to create scripts that clean, shape, and manipulate data before it is loaded into Power BI.
In addition to DAX and M, Power BI also uses other programming languages, such as C# and JavaScript, in its underlying technology. These languages are used to create custom connectors, custom logic, and custom extensions for Power BI, and to provide a rich development environment for building advanced custom solutions.
Microsoft Power Apps is developed using a proprietary low-code/no-code platform and a visual programming language. The platform provides a visual interface for building custom applications and automating workflows, and it allows users to create custom forms, custom connectors, and custom logic without writing any code.
However, for more advanced customizations and integrations, Power Apps provides the ability to use JavaScript and Microsoft Power Automate to add custom code. This allows developers to extend the capabilities of Power Apps and build custom solutions that meet the specific needs of their organization.
In summary, Microsoft Power Apps is developed using a visual programming language and platform, with the ability to use JavaScript and Microsoft Power Automate for more advanced customizations and integrations.
Power Pages : is a new feature in Microsoft Power Apps, and it is developed using the same proprietary low-code/no-code platform and visual programming language as the rest of Power Apps.
Power Pages provides a visual interface for building custom pages for Power Apps, and it allows users to create custom forms, custom logic, and custom integrations without writing any code. Like the rest of Power Apps, Power Pages also provides the ability to use JavaScript and Microsoft Power Automate for more advanced customizations and integrations.
In summary, Microsoft Power Pages is developed using the same proprietary low-code/no-code platform and visual programming language as the rest of Microsoft Power Apps, with the ability to use JavaScript and Microsoft Power Automate for more advanced customizations and integrations.
