Hi, How do I copy and paste the rest of the columns into the calculated column especially for larger size images creates a lot of columns for example my image had 200 columns how to copy and paste it into the calculated column like you did.
Hello there. If you have a big size image you can use Python to reduce the size, you will get much less columns. Here is a detailed tutorial: Learn how to create Interactive timelapse in Power BI th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
Hello 👋, the Python script is stored in the PowerBI file available in the link. Once you open the PowerQuery editor you will find a step containing the script
This is awesome! Thank you. I’m going to try saving images into a google drive folder, then write some App Script code to loop through and save the pictures as base64 into a google sheet, then import the sheet into PBI.
You are welcome! Sounds like a plan. Remember you can download the PowerBI file and the script from the description, this should give you a head start. Best of luck!
In case anyone is reading this it is possible, but setting the google drive folder to public and linking the docs in a google sheet is much much easier. You don’t have to worry about file size that way.
great video - love the python solution - was using the power query bit64 formula but it was cutting off part of the image. your python solution worked. Thank you Sir, respect to your name.
Hello there… yes please check this video Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
Thank you for making this video! If anyone has a similar issue to me, when following the previous video to install Python, I had to also add Pandas via the Command Prompt (pip install pandas) because I had an error when trying to run the script in Power Query stating Pandas was not installed
This is Amazing, Thank you so Much Does method 3 work if the Image path is a URL (online links)since am storing the images on the SharePoint(Onedrive)?
Hello 👋🏼. Thank you for your comment. Yes you can, actually you can use URL’s directly without the need to convert to base64. The only thing you need to make sure that the OneDrive or SharePoint folder is public
@@NextGenBIGuru the problem is a business Onedrive, so it is not allowed to make it public That is why I am searching for a workaround to convert it to base64, but till now I can't do it in the way in the video, can you please help me and tell me how to do it with the URL path, not a local path, thank you so much!
If I have a Sharepoint Drawing Library containing a largre amount of PDFs (+1000), and I use PowerBI as a front end for navigation of data set... Can get an image / pdf preview within Power BI? Either tile view, or a hover over preview? Same qustion for a Document Library containing a photo library with jpegs
Hello 👋🏼, if they are in on of the image formats you can easily do this using URL. If they are pdf format you still can but you need to process them into base64 format using Python. Check this tutorial: Seamless PDF Embedding In Power BI: Elevate Your Reporting Game | NextGen BI Guru th-cam.com/video/AU3rthIFLOE/w-d-xo.html
Thanks for this video, this helps me a lot. Can you make a video using a Shareponit folder with the url of the image of the Sharepoint and converting to base64 using the python script. Regards.
Hello 👋🏼, you are most welcome. If you have your images in a SharePoint folder you job would be much easier you don’t need to convert your images to base64. You just use the URL of the images and feed it to the image viewer. The only thing you need to make sure that the folder has is public.
Hi Abdullah, I hope I understood your question. You are trying to show an image with title/description below it or something like that. If this is the case, I highly recommend to go with HTML visual, the following tutorial is about structuring text for HTML visual, but you can use similar approach to add image too. How to Use HTML in Power BI for Amazing Dashboards | NextgGen BI Guru th-cam.com/video/fFyK_-WK2A4/w-d-xo.html
Hello 👋🏼, this means you are exceeding the limits of characters for a cell. An easy work around would be resizing the images. See this tutorial for details: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
Hello 👋🏼, based in my understanding to your description. This means that the URL is not public, or simply the images folder or location has access rights with private links. So you need to use images with public links to be able to refresh the data on Power BI service
@@NextGenBIGuru Thanks for reply 🥰, I thought that converting the image path to Base64 might circumvent permission requirements. According to some forums that for displaying images on mobile devices, anonymous viewing mode is preferred. However, if that's not possible, Base64 encoding seems to be the alternative solution. I would like to ask for some opinion from you, please?
Hello 👋🏼, using base64 for images is good strategy as it will store the images within your PBI file. But remember that these images are not online they are converted to base64 and stored in your file. Now if you want to update images you need to read these images from a folder, simple OneDrive folder with public links can do the job and the images will be linked to your report and you can refresh it in PowerBI service. Another way is to embed a python code in your PBI file that convert images from any folder into base64 and show them in your report. Have a look to this project to understand how it works: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru th-cam.com/video/uVWfeWPq-3w/w-d-xo.html Just remember if you are dealing with local folders you can’t refresh these images in PowerBI service unless you have gateway installed and setup
@@NextGenBIGuru Great 😍 thanks! I'll attempt a Python solution and share the outcome later. Oh, method 3 is work for me? or i should do PowerBI Timelapse, my data is private in Sharepoint.
I implemented the solution using Python, but there's still a problem about data privacy. Moving the data from SharePoint to a public storage might be the most suitable option.
Hi. It is wonderful. That is what I need exactly.
Where can I get python code of method 3?
Thanks for your useful information.
Hi. You are welcome. You can download the PowerBI file from the link in the description. It contains the Python script too.
Thanks a lot for the informative tutorials.
You are most welcome!
Hi, How do I copy and paste the rest of the columns into the calculated column especially for larger size images creates a lot of columns for example my image had 200 columns how to copy and paste it into the calculated column like you did.
Hello there. If you have a big size image you can use Python to reduce the size, you will get much less columns. Here is a detailed tutorial: Learn how to create Interactive timelapse in Power BI
th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
hi. could you lead me to the python script?
It seem to be unavailable on the link in the description. thank you
Hello 👋, the Python script is stored in the PowerBI file available in the link. Once you open the PowerQuery editor you will find a step containing the script
This is awesome! Thank you.
I’m going to try saving images into a google drive folder, then write some App Script code to loop through and save the pictures as base64 into a google sheet, then import the sheet into PBI.
You are welcome! Sounds like a plan.
Remember you can download the PowerBI file and the script from the description, this should give you a head start. Best of luck!
In case anyone is reading this it is possible, but setting the google drive folder to public and linking the docs in a google sheet is much much easier. You don’t have to worry about file size that way.
Amazing video, how can I get the Python code? Thanks!
Hello 👋, thank you for your feedback. You will find a link in the description to download the PowerBI file it contains the script too
great video - love the python solution - was using the power query bit64 formula but it was cutting off part of the image. your python solution worked. Thank you Sir, respect to your name.
Hello 👋, glad you found it useful and thanks for your kind words
@@NextGenBIGuru how could we solve the problem of refreshing the model automatically with the python script?
Please have you done the video with workaround on the size issue of method 3?
Hello there… yes please check this video Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru
th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
@@NextGenBIGuru Thank you
Anytime
Thank you for making this video! If anyone has a similar issue to me, when following the previous video to install Python, I had to also add Pandas via the Command Prompt (pip install pandas) because I had an error when trying to run the script in Power Query stating Pandas was not installed
You are welcome, glad you found it helpful! It is true that you need to install some additional libraries like Pandas.
Thank you for this amazing video. Where is the link for BI file, I can not seem to find it in description. Please help as soon as possible!!
Hello, the link in the video description. But here it is anyway: github.com/NextGenBIGuru/ImagesInPowerBI.git
This is Amazing, Thank you so Much Does method 3 work if the Image path is a URL (online links)since am storing the images on the SharePoint(Onedrive)?
Hello 👋🏼. Thank you for your comment. Yes you can, actually you can use URL’s directly without the need to convert to base64. The only thing you need to make sure that the OneDrive or SharePoint folder is public
@@NextGenBIGuru the problem is a business Onedrive, so it is not allowed to make it public That is why I am searching for a workaround to convert it to base64, but till now I can't do it in the way in the video, can you please help me and tell me how to do it with the URL path, not a local path, thank you so much!
Amazing methods Hamzeh...Peace
Thank you Deshminder! ❤️
If I have a Sharepoint Drawing Library containing a largre amount of PDFs (+1000), and I use PowerBI as a front end for navigation of data set... Can get an image / pdf preview within Power BI? Either tile view, or a hover over preview?
Same qustion for a Document Library containing a photo library with jpegs
Hello 👋🏼, if they are in on of the image formats you can easily do this using URL.
If they are pdf format you still can but you need to process them into base64 format using Python. Check this tutorial:
Seamless PDF Embedding In Power BI: Elevate Your Reporting Game | NextGen BI Guru
th-cam.com/video/AU3rthIFLOE/w-d-xo.html
Followed all the steps but whenever I click the "Table" for "df", it says "This table is empty". How do I solve this?
Hello my friend, can you share the minute is the video you are referring to
same problem also me
Thanks for this video, this helps me a lot.
Can you make a video using a Shareponit folder with the url of the image of the Sharepoint and converting to base64 using the python script.
Regards.
Hello 👋🏼, you are most welcome.
If you have your images in a SharePoint folder you job would be much easier you don’t need to convert your images to base64. You just use the URL of the images and feed it to the image viewer. The only thing you need to make sure that the folder has is public.
But what if it is can't be made public
Can we have an image URL +text in one column in Matrix
Hi Abdullah, I hope I understood your question. You are trying to show an image with title/description below it or something like that. If this is the case, I highly recommend to go with HTML visual, the following tutorial is about structuring text for HTML visual, but you can use similar approach to add image too.
How to Use HTML in Power BI for Amazing Dashboards | NextgGen BI Guru
th-cam.com/video/fFyK_-WK2A4/w-d-xo.html
can I have python code to copy in my power bi ?
Hello 👋🏼 , you will find in the description a link to download the file including the python Script
Amazing
Thank you Abdilrazak
I tested it . Result is perfect. But image did not seem fully. What can I do, to see fully
Hello 👋🏼, this means you are exceeding the limits of characters for a cell. An easy work around would be resizing the images. See this tutorial for details: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru
th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
Thanks a lot
You are welcome my friend
When i do Method 2 with my image URL, i have problem with Dynamic URL which make me can't refresh Data in Power Bi Website. Anyone help me pls 😓😓😓
Hello 👋🏼, based in my understanding to your description. This means that the URL is not public, or simply the images folder or location has access rights with private links. So you need to use images with public links to be able to refresh the data on Power BI service
@@NextGenBIGuru Thanks for reply 🥰, I thought that converting the image path to Base64 might circumvent permission requirements. According to some forums that for displaying images on mobile devices, anonymous viewing mode is preferred. However, if that's not possible, Base64 encoding seems to be the alternative solution. I would like to ask for some opinion from you, please?
Hello 👋🏼, using base64 for images is good strategy as it will store the images within your PBI file. But remember that these images are not online they are converted to base64 and stored in your file.
Now if you want to update images you need to read these images from a folder, simple OneDrive folder with public links can do the job and the images will be linked to your report and you can refresh it in PowerBI service.
Another way is to embed a python code in your PBI file that convert images from any folder into base64 and show them in your report. Have a look to this project to understand how it works: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru
th-cam.com/video/uVWfeWPq-3w/w-d-xo.html
Just remember if you are dealing with local folders you can’t refresh these images in PowerBI service unless you have gateway installed and setup
@@NextGenBIGuru Great 😍 thanks! I'll attempt a Python solution and share the outcome later. Oh, method 3 is work for me? or i should do PowerBI Timelapse, my data is private in Sharepoint.
I implemented the solution using Python, but there's still a problem about data privacy. Moving the data from SharePoint to a public storage might be the most suitable option.
Followed all the steps but whenever I click the "Table" for "df", it says "This table is empty". How do I solve this?
Hello 👋, it is hard to tell what is the problem but it seems the script didn’t produce the output for some reason