topic what is data type of workspace id? In sql database which data types choose to store work-space id? in Developer

what is data type of workspace id? In sql database which data types choose to store work-space id?

aishwarya08 — Mon, 09 Apr 2018 10:38:54 GMT

Text - A Unicode character data string. Can be strings, numbers, or dates represented in a text format. Maximum string length is 268,435,456 Unicode characters (256 mega characters) or 536,870,912 bytes.

Re: what is data type of workspace id? In sql database which data types choose to store work-space i

v-micsh-msft — Wed, 11 Apr 2018 08:32:46 GMT

Under Power BI REST API document, it is marked as "string " for the group id (Workspace Id).

For example, the body of the Get Groups action:

{
  "odata.context": "string",
  "value": [
    {
    "id": "string", 
    "name": "string", 
     "isReadOnly": true, 
    "isOnDedicatedCapacity": true, 
     "capacityId": "string" 
    }
  ]
}

Which should be an GUID,

a 128-bit number used to identify information in computer systems. In its canonical textual representation, the sixteen octets of a UUID are represented as 32 hexadecimal (base 16) digits, displayed in five groups separated by hyphens, in the form 8-4-4-4-12 for a total of 36 characters (32 alphanumeric characters and four hyphens).

Search for Microsoft GUID in this article.

So if you would like to store this information into SQL Server, make sure the string field is longer than 128 bit.

Regards,

Michael

Re: what is data type of workspace id? In sql database which data types choose to store work-space i

aishwarya08 — Thu, 12 Apr 2018 13:48:09 GMT

Thank you for giving answer but can you tell me exact wich data type I used meaning in sql after 128 bit there 256 bit.
In future it may be bigger than 256 bit or not.