Microsoft Power BI
ID powerbi
other
Microsoft Power BI is a business intelligence service with a desktop report editor. In Power BI Desktop the author sets a data category on a column, such as City, Postal code, Latitude, Web URL or Barcode, to tell Power BI how to use its values: geographic categories are sent to Bing Maps for geocoding, Web URL and Image URL turn values into links or pictures, and Barcode lets the mobile app filter a report by a scanned code. The category is set by hand and is not inferred from the values. The categories are described in the Power BI documentation on data categorization, map tips, hyperlinks, images and barcodes.
- Website
- https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-data-categorization
- Supported types
- 11
Supported semantic types
| ID | Name | Categories | Countries | Description |
|---|---|---|---|---|
| address | Address (physical location) PII | common, pii, geo | global | Geographic address, commonly consist of postindex, country, area, town, street and building |
| admin_area_1 | First-level administrative division draft | geo | global | Name or code of the largest administrative subdivision of a country, such as a US state, a Canadian province, a German Land or a Russian... |
| admin_area_2 | Second-level administrative division draft | geo | global | Name or code of a subdivision of a first-level administrative division, such as a US county, an Italian province or a French department.... |
| city | City PII | geo, pii, common | global | A city is a large human settlement. It can be defined as a permanent and densely settled place with administratively defined boundaries... |
| continent | Continent name or identifier | geo | global | A continent is any of several large landmasses. Related to UN unm49 dataclass |
| country | Country code or name | geo | global | A country is a distinct territorial body or political entity. It may be an independent sovereign state or part of a larger state,[2] as... |
| latitude | latitude | geo, common | global | In geography, latitude is a geographic coordinate that specifies the north–south position of a point on the Earths surface. Latitude is... |
| longitude | Longitude | geo, common | global | Longitude is a geographic coordinate that specifies the east–west position of a point on the Earths surface, or the surface of a... |
| postindex | Postal code/index PII | geo, pii, common | global | Postal index/code, unique post identifier used in address |
| street_address | Street address line PII draft | geo, pii | global | First line of a postal address: the house or building number and the street name, such as 10 Downing Street or Unter den Linden 77. The... |
| url | Uniform Resource Locator (URL) | common, internet | global | Address of a resource on a network that also says how to retrieve it: a scheme such as https, a host, an optional port, a path, a query... |
Use this record
- JSON: API v1 · legacy shape
- Improve it: edit
data/tools/other/powerbi.yamlon GitHub