Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
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:
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"}}
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.
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.
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.
3. In the Modelling tab, change the Image column ([Logo]) to the Image URL data category.
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
105 | |
98 | |
39 | |
30 |