Microsoft provides various different types of database software with various compatible query languages:
* With Power BI and Power Query for Excel one can query the data model stored in these programs using the DAX language. However, to manipulate the data as its being brought into the model, these programs allows you to use a language called Power Query Formula Reference (informally known as "M").
| Database | Compatible Query Language |
| Microsoft Access | SQL |
| Microsoft SQL Server | TSQL |
| Microsoft SQL Server Analysis Services Multidimensional Cubes | MDX |
| Microsoft SQL Server Analysis Services Tabular Models | DAX / MDX |
| Microsoft Power BI* Microsoft Power Query for Excel* |
DAX* |
* With Power BI and Power Query for Excel one can query the data model stored in these programs using the DAX language. However, to manipulate the data as its being brought into the model, these programs allows you to use a language called Power Query Formula Reference (informally known as "M").
No comments:
Post a Comment