# Converting HTTPs link images/icons to Base 64 in Power BI If you have a column of images/icons in https links format like below:

Image 1: Column of https links for images/icons

Then you can convert it to base 64 URL format, which is the acceptable format by the xViz Performance Flow visual (as it is certified):

Image 2: Columns of Base 64 URLs for images/icons

### Steps to be followed in Transform Editor/Power Query: #### Step 1: Create a Custom Function in your Power BI report -> Transform Data: 1. Home → New Source → Blank Query

2. Change the name of the query to Query1 to *ImgtoBase64Url* and Click on Advanced Editor

3. Paste the below code and Click on Done: ```powerquery let Source = (ImageUrl as text) as text => let BinaryContent = Web.Contents(ImageUrl), Base64 = "data:image/jpeg;base64, " & Binary.ToText(BinaryContent, BinaryEncoding.Base64) in Base64 in Source ``` **Note:** The prefix of "data:image/jpeg;base64, " must be adjusted as per the image extension, i.e. replace the "jpeg" with the extension of the image that you are using (eg: png, etc.) #### Step 2: Invoke the custom function in the data: 1. Add Column → Invoke Custom Function

2. Add the following details in the popup: 1. Provide a name for the new column 2. Select the function query name “*ImgtoBase64Url*” 3. Select the column with Images URL

Figure 2: Invoke Custom Function dialog box

**Result:** This will result in a new column named "Image" which will contain the Base 64 URLs. Use this column in the xViz Performance Flow visual. Here is an **example** report file: {% file src="" %} {% hint style="info" %} If the images you are referring are of high resolution which results in over 33,000 characters in base 64 format, then you might see only partial image rendering because of the character limit in Power BI. Check out this page for the solution - [handling-long-base-64-urls-in-power-bi](https://docs.xviz.com/performance-management/display-data-in-the-cards/images/handling-long-base-64-urls-in-power-bi "mention") {% endhint %}