Tools

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

IDNameCategoriesCountriesDescription
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