Text Truncation issue

[prateekraina]

Hi,

While importing data from Azure Cosmos DB, the text is getting truncated in Query Editor.

The string represents a Base 64 image.

Original Size in Cosmos DB is 123160 bytes - 126115 characters

Size when loaded in Power Query Editor is 1024 bytes - 1024 characters

As per documentation, 536,870,912 bytes are allowed.

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-data-types#text-type

Please look into it.

Prateek Raina  

[v-jiascu-msft]

Hi @prateekraina,

How can I reproduce it?

Best Regards,

Dale

[prateekraina]

@v-jiascu-msft,

1. Go to Query Editor.

2. Click on Enter Data.

3. Enter Base64 string of an image stored in text file at this location.

4. Close and apply.

5. Choose Data Category as Image URL.

6. Open this image in any visual that supports images. I chose Image viewer by Cloudscope.

You will notice that entire image doesn't load.
Here is the screenshot:
Actual ImageImage in Power BI

The size of the string is 679920 bytes so it should not be truncated. However, if you look in query editor the string is truncated.

Let me know if you need any more information.

Prateek Raina

[kashmirkhan09]

I also have a problem that when I try to publish an report to the PowerBI benefit frome PBI Desktop, yet I haven't effectively marked in, afted I do it, the application crashes out of the blue. However, I want best assignment help but hope someone must tell the solution of this problem.

[prateekraina]

 @Vicky_Song @v-jiascu-msft

Its been 3 months and still no updates? Atleast acknowledge the bug and pass it to the team.

Prateek Raina