Hello 👋🏼. Thank you for your comment. You can actually use xlsx too. Usually csv files are lighter equivalent to text files. But again if you are more comfortable with xslx you could use them too

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

Hello 👋🏼, did you download the Power BI file and contents? Here is the link to download them: github.com/NextGenBIGuru/ConstructionTimelapse.git Hope this helps

@@NextGenBIGuru yes, I already download the content, but I tried to apply the same steps and code on my own dashboard, the result was empty DF Table.

If you need special help in your project, please feel free to send your project details to [email protected] and I will connect you with a specialist who can help you with your project.

Hello 👋🏼. Yes you can both calculated columns or measures are possible. If you have specific customization you need help with, send your requirements to [email protected] and I will connect you with a specialist who can do them for you.

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.

Thank you! Glad you liked it

Thank you. Glad you found it useful

Hello 👋🏼. Glad you found it useful. For 1 - yes blank rows will be skipped, the workaround is to use replace nulls from query editor with 0’s or any other value. For 2-4 - unfortunately PowerAutomate takes long time to finish especially as the no. Of rows grows, the workaround is to duplicate the flow many times (say 3 in your case) then filter the query for each one based on one of the fields. And let them run simultaneously. Not perfect, but worked for me in a similar situation. Hope this helps.

Hello 👋🏼, thank you. Send your request to [email protected] and I will hook you up with a specialist who can develop this specific feature for you

Hello 👋🏼, this is just a unique ID or index for each row I used it to count records. You can easily generate an index column from Power Query, there is an option to create an index column

@@NextGenBIGuru I don't understand the video after 2 minutes 40 seconds, I am unsure why the ref column is used and how its created using Power Query.

You're welcome!

Thank you 🙏. I am glad you found it helpful

Hello 👋🏼 thanks for the tip

Hello 👋🏼 use the default template it loads all the components in the file for you and you can create tables of quantities with ease

Hi, Thanks.

I have downloaded the default template after uploading the IFC on VCAD but when I open the template, It is asking "Access Web content". Do you know about it?

Hello 👋🏼, apologies for the mistake and confusion, the first is the correct one.

@@NextGenBIGuru thanks for the clarification. I really appreciate. Do you do 1-on-1 training/consultation on more complex projects?

For some reason, after I did the advanced matrix, some cells are still blanks. What could I be doing wrong? I wish I can upload the screenshot below.

Hi! I just resolved the issue. But is there a way to implement control ratings into this matrix?

Hello 👋🏼 - of course you can, it is all about how you build your data model. If you have specific project requirements, feel free to email me on [email protected].

You are most welcome. Thank you for you comment

شكرا صديقي 🙏

Hello 👋🏼, if you mean that you want to prevent the slicer from filtering the data shown in the matrix then you need to edit slicer interactions. Here is how you do it: learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop But if you want to filter the data without affecting the structure of the matrix then please follow this tutorial: Power BI Tutorial: Create An Advanced Risk Matrix Visual - P2 | NextGen BI Guru kzbin.info/www/bejne/iZjbdoGaf8hrb5I

Thank you 🙏

Thank you my friend

Hello 👋🏼, there is no direct link according to my knowledge. However you can use mapbox visual instead. Check this tutorial: Boost Your Dashboards: Engaging 3D Maps In Power BI With Mapbox - 2024 Guide | NextGen BI Guru kzbin.info/www/bejne/bKfZl4mvrJ2No7s

1st: Based on your description it means Python is not installed properly. 2nd: you don’t need to worry about installing R it is not used in this file. Once you have Python installed properly and mapped to PowerBI, it will work properly. Hope this helps

@@NextGenBIGuru Thank you , i have installed PIP commands and linked python into power BI , then in Transform data , in Run python script , i didnt get the code ? how to get the code?

The script is embedded in the pbix file. But in any case, I uploaded the code in a text file to the same repository. Just copy it from there

@@NextGenBIGuru one more question, How to have embedded dates into images? like we have pictures in our folder with any name, and we know which date it has been taken, how you have given this number of dates ?

The easiest way is to have it in the photo name then you extract it in power query

Hello 👋🏼, yes it does based on your data

Hello, the link in the video description. But here it is anyway: github.com/NextGenBIGuru/ImagesInPowerBI.git

Hello 👋🏼, I simply create a function in excel to build it. But you can also download the PowerBI file from the description and you will find the calculated column.

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 kzbin.info/www/bejne/q4e6l5iNhdZgadk 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.

Hello 👋🏼, thanks for your feedback! In your case you need to divide them into pages. Luckily you can automate it. Check out this tutorial: Elevate Your Dashboards: Power BI Techniques For PDF Content Search | NextGen BI Guru kzbin.info/www/bejne/mobCqJqbqrV4aMk

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 kzbin.info/www/bejne/q4e6l5iNhdZgadk

Thanks a lot

You are welcome my friend

Thank you 🙏

Hello 👋🏼, not in a direct way but you can have a work around. Here is a tutorial to explain it: Data Alerts With Power BI & Automate: Advanced Strategies - P2 | NextGen BI Guru kzbin.info/www/bejne/mGGwhIeNrbF3qc0

Thank you 🙏

Hello 👋🏼, yes Microsoft introduced Copilot for Power BI. It is an AI engine that helps to use AI models for your data and building dashboards too. Look it up.

Hello 👋🏼, null values are treated as no data. To overcome this, use the replace value option in query editor. Just replace null with any value like 0 or -

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 kzbin.info/www/bejne/d4aWo6eefqt_hac

Hello 👋🏼, thanks for your feedback. Yes there is, her is the tutorial: Boost Your Dashboards: Engaging 3D Maps In Power BI With Mapbox - 2024 Guide | NextGen BI Guru kzbin.info/www/bejne/bKfZl4mvrJ2No7s

Hello 👋🏼 , you will find in the description a link to download the file including the python Script

Hello 👋🏼, this is probably because you have the column in datetime format. You need to convert it to text format first. Create a new calculated column using FORMAT function in DAX to have the datetime converted to text. Then combine all columns using another calculated column.

@@NextGenBIGuru Thank you, I'll try this and revert with feedback.

@@NextGenBIGuru I have done that using dax. I change the format to text, then I grouped the columns together. It worked but am only see one milestone per product, when I use tabel to view the milestone data I'll see the complete data. While on the HTML content visual I can only see one. Please assist🙏

I can’t help much without seeing the file. Please download the Power BI file used in the tutorial it’s available in a link from the description. Then take the code from this and use ChatGPT to update it for you.

@@NextGenBIGuru Thank you so much. I am fine now. I used calculated table to achieve it and it's working fine.

Thank you

Hi Hassan, I am not if I understood your question but it seems that you have problem with the data model. Did you download the dashboard? Are you using more than one table connected together?

Thank you for your kind words

Hello 👋🏼. Thank you. Noted, I will keep it in mind.

You are most welcome. Glad it helps.

Hello 👋🏼, here is the full report video: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru kzbin.info/www/bejne/q4e6l5iNhdZgadk

Thanks you 🙏

Hello 👋🏼, It is a Power BI report designed for Power BI mobile app. So technically you are correct it is a Power BI report not a dashboard.

@@NextGenBIGuru got it, thanks for clarifying

Hello 👋🏼, I am not aware of a course that is specific to this topic. However, there are many courses on creating interactive dashboards let me know if you need me to share some. Also, I will add it to my topics list and will try to cover it in the near future.

Thank you for addressing the inclusion of construction risk management in your KZbin channel. I eagerly anticipate your forthcoming videos.

You are welcome 🙏

Hello 👋🏼, thanks for your comment. I will put it in my topics list. Meanwhile, I have created construction progress animated report before. Have a look: Awesome Power BI Timelapse: A Step-By-Step Tutorial | NextGen BI Guru kzbin.info/www/bejne/q4e6l5iNhdZgadk

Hello 👋🏼, thanks for your comment. I’ll put it in my topics list

Hello 👋🏼, thanks for your comment. I’ll put it in my topics list.

Thank you, this is very kind of you ❤️