Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
danextian
Super User
Super User

32766 characters cell limit workaround?

‎03-26-2018 05:50 PM

Hi everyone,

 

I am trying to change the encoding of my image files to base64 within power query using Binary.ToText function and use the result  as image  URLs. However, not all images are loading completely since the the base64 conversion is more than the cell characer limit. Any known workaround?










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Labels:
Message 1 of 4
1,569 Views
3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

‎03-28-2018 12:50 AM

@danextian,

How about you upload these image files to OneDrive, then use the image URLs in Power BI Desktop?
https://www.fourmoo.com/2017/09/26/power-bi-using-onedrive-to-embed-and-host-images-for-power-bi/

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 4
1,545 Views
0
danextian
Super User
Super User
In response to v-yuezhe-msft

‎03-28-2018 07:16 AM

@v-yuezhe-msft,

 

Does PBI Desktop have a Onedrive connector?










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 3 of 4
1,540 Views
0
v-yuezhe-msft
Microsoft Employee
Microsoft Employee
In response to danextian

‎04-02-2018 02:12 AM

@danextian,

You are able  to connect to files on OneDrive using web connector in Power BI Desktop. And you can use SharePoint Folder connector to connect to OneDrive folder.

In your scenario, you would need to copy embed image URL to Excel and import Excel file to Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 4 of 4
1,531 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All