Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
polandoz15
Frequent Visitor

Display uploaded images from OneLake in Power BI

Greetings fellow PBI nerds!

I'm looking to enhance our Power BI dashboards by integrating employee photos stored on OneLake. My goal is to upload and store these images securely in OneLake and then access them within Power BI for visualization purposes. I have tried to use the URL from the OneLake, but it doesn't seem to work (copied from Lakehouse: "https://onelake.dfs.fabric.microsoft.com/***/***/Files/Miscellaneous/Ted.jpg".

 

I have also tried to access image files outside OneLake. I have used this one: https://www.countries-ofthe-world.com/flags-normal/flag-of-Malta.png, then I have changed the data category to Image URL. Didn't help either. 

 

Does anyone have experience with accessing images from OneLake (Lakehouse) to Power BI? 

 

Thank you for your assistance!

2 REPLIES 2
polandoz15
Frequent Visitor

Thanks for the reply @v-kaiyue-msft! It still doesn't seem to be working. The way you proposed works fine when I am using a URL outside OneLake, so that's ok I guess. But when I point to the jpg-file I want to display from OneLake, it doesn't work. 


I am copying the URL from OneLake, like this:
test2.png

I get this message when trying to view the image from the URL:

{"error":{"code":"Unauthorized","message":"Authentication Failed with Bearer token is not present in the request"}}

 

v-kaiyue-msft
Community Support
Community Support

Hi @polandoz15 ,

 

If you want to add an image to the report, you can create a column using the URL of the image. Select the column. On the Column Tools ribbon, for the Data category, select Image URL.

vkaiyuemsft_0-1713938024706.png

 

One thing to note:
- The image needs to be in one of the following file formats: .bmp, .jpg, .jpeg, .gif, .png or .svg
- The URL must be accessible anonymously and not on a site that requires a login, such as SharePoint or OneDrive for work or school.
- The Power BI Mobile app displays images only if the image URL is accessible anonymously. An image cannot be hosted on a site that requires a login, such as SharePoint, even if you can see the image in Power BI Desktop or Services.
For more information, see the documentation: Display images in a table, matrix, or slicer in a report - Power BI | Microsoft Learn

 

You can also use images stored in sql server tables with power bi.
1. Change the binary column to text.

vkaiyuemsft_1-1713938134623.png

 

2. Create a custom column and append a URI to tell Power BI that these are png images. If using jpeg, use jpeg instead of png.

vkaiyuemsft_2-1713938144397.png

 

3. In the Modelling tab, change the Image column ([Logo]) to the Image URL data category.

vkaiyuemsft_3-1713938153114.png

 

For more details, please refer to the link: Solved: How to use Images Stored in a SQL Server Table wit... - Microsoft Fabric Community

 

OneLake offers a semantic modelling integration that is currently in preview and has certain prerequisites and limitations to consider.
Prerequisites:
Ensure that you have one or more import semantic models in the workspace in Power BI Premium or Fabric Capacity.
The Large Semantic Model Storage format must be enabled for the model.
Permissions:
You need model participant permissions (read, write, browse) to access the contents of the model folder.
Therefore, you need to ensure that your url is accessible. More details can be found in the documentation: Learn about Microsoft OneLake Delta table integration in Power BI and Microsoft Fabric - Power BI | ...

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors