Power BI Connector for CSV

Build 24.0.9060

Column Definitions

The basic attributes of a column are the name of the column, the data type, whether the column is a primary key, and the internal name. The connector uses the internal name to extract nodes from CSV with no readable names.

Mark up column attributes in the api:info block of the schema file. You can set the internal name in the other:internalname property. You can also specify the format of the resulting column value with other:valueFormat. To see the column definitions in a complete example, refer to Modeling CSV Data.

<api:info title="CSVPersons" desc="Parse the CSV Persons feed.">
  <attr name="ID"           xs:type="int"        key="true"                                            />
  <attr name="EmployeeID"   xs:type="int"                             other:internalname="employee_id" />
  <attr name="Name"         xs:type="string"                                                           />
  <attr name="TotalExpense" xs:type="double"                                                           />
  <attr name="HireDate"     xs:type="datetime"                                                         />
  <attr name="Salary"       xs:type="int"                                                              />
</api:info>

Defining the internal name

The other:internalname property is used to specify the CSV column name that selects the column's value from CSV. So, if the CSV file contains a column name employee_id you use other:internalname="employee_id"

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060