Forum Discussion
what is data type of workspace id? In sql database which data types choose to store work-space id?
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
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
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.
