Support formation Rapports Power BI
Langage M
3 | Accès et combinaison des données
Accès aux fichiers et dossiers
Fonctions M pour différents formats de fichiers
Format de fichier
Fonctions M
1
Azure Storage
AzureStorage.BlobContents, AzureStorage.
Blobs, AzureStorage.DataLake, AzureStorage.
DataLakeContents, AzureStorage.Tables
2
Binary
File.Contents
3
Excel
Excel.Workbook, Excel.CurrentWorkbook
4
Folder
Folder.Contents, Folder.Files
5
HDFS
Hdfs.Contents, Hdfs.Files
6
HDInsight
HdInsights.Containers, HdInsight.Contents,
HdInsight.Files
7
JSON
Json.Document
8
PDF
Pdf.Tables
9
RData
RData.FromBinary
10
Text/CSV
Csv.Document
11
XML
Xml.Document, Xml.Tables
There are no rows in this table
File.Contents
Récupération de contenu Web
Text/CSV
Investigation des fonctions binaires
Accès aux bases de données et aux cubes
Les functions M pour accèder aux bases de données et aux cubes
System
System 2
Description
M Functions
1
Microsoft SQL Server
Microsoft SQL Server
Microsoft’s relational database system.
Sql.Database
Sql.Databases
2
Microsoft Analysis Services
Microsoft Analysis Services
Refers to SQL Server Analysis Services (SSAS) and Azure Analysis Services (AAS). Supports both
tabular and multidimensional cubes. Tabular
cubes use Data Analysis Expressions (DAX) for queries and calculations while Multidimensional cubes use Multidimensional Expressions (MDX) for the same.
AnalysisServices.
Database
AnalysisServices.
Databases
3
Microsoft Access
Microsoft Access
The relational Access Database Engine (ACE), formerly the Jet database engine.
Access.Database
4
Adobe Analytics cubes
Adobe Analytics cubes
Adobe Experience Cloud’s cube analytics service, a leading system for web analytics. Adobe Experience Cloud was formerly known as Adobe Marketing Cloud. Adobe Systems acquired the analytics components of Adobe Experience Cloud from Omniture.
AdobeAnalytics.Cubes
5
IBM DB2
IBM DB2
A relational database system developed by IBM.
DB2.Database
6
IBM Informix
IBM Informix
A relational database system originally developed by Informix, which was acquired by IBM in 2001.
Informix.Database
7
Oracle Essbase
Oracle Essbase
A multidimensional cube system originally developed by Arbor Software Corporation, which merged with Hyperion Software in 1998. Oracle later acquired Hyperion Solutions Corporation and originally marketed Essbase as DB2 OLAP Server.
Essbase.Cubes
8
Oracle MySQL
Oracle MySQL
MySQL is a free and open-source relational database released under the GNU General Public License in 1995. Originally owned and sponsored by the company MySQL AB, which was acquired by Sun Microsystems, which was itself acquired by Oracle in 2010.
MySQL.Database
9
Oracle Database
Oracle Database
Commonly referred to as simply Oracle, Oracle Database is a relational database that supports OLTP and data warehouse workloads.
Oracle.Database
10
PostgreSQL
PostgreSQL
Also simply known as Postgres, PostgresSQL is a free and open-source relational database originally released in 1996.
PostgreSQL.Database
11
SAP HANA
SAP HANA
A column-oriented, in-memory, relational database system developed by SAP.
SapHana.Database
12
SAP Business Warehouse
SAP Business Warehouse
Originally a relational database, SAP’s Business
Warehouse later evolved to leverage the SAP HANA in-memory database and provide advanced OLAP functionality.
SapBusinessWarehouse.
Cubes
13
SAP Sybase
SAP Sybase
A relational database system originally created by Sybase and then later acquired by SAP.
Sybase.Database
14
Teradata
Teradata
Teradata’s relational database system.
Teradata.Database
There are no rows in this table
Travailler avec des protocoles de données standard
Adressage de connecteurs supplémentaires
Combiner et assembler des données
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.