Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |