Видео

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.

Thanks for the useful video. The 'total risk' shows zero in table but the zero is not displayed in the matrix. What is the reason? Thank you

nice one!

Followed all the steps but whenever I click the "Table" for "df", it says "This table is empty". How do I solve this?

Tried watching...music was too annoying. Looking for another video

Great video but how do i identify the unique ID# to the plots?

This wont work with live connection or directquery mode only import ? thank you

Any advice on stopping the matrix from adjusting column/row counts when you apply filters? For example, if I want to set up a filter to filter out risks assigned to certain team members on the report page. At the minute the counts work but the matrix reduces in size which isn't ideal.

Great video! However, I realized that I can have up to 60 columns concatenated. There is still limitations from PBI, I assume: The function 'PLACEHOLDER' encountered a Text that exceeded the maximum allowable length. Are you aware of that or is not the best practice to do this?

Thanks you very much

Hi thanks Alot dear for this , I would like to know please if you can advise If I'll connect the pdf files with the main dashboard For e.g if I have a sales pie chart on the main dashboard and I'll click on it then sales details in pdf will open Please advise if there is an option for this , would really appreciate

Hi thanks Alot dear for this , I would like to know please if you can advise If I'll connect the pdf files with the main dashboard For e.g if I have a sales pie chart on the main dashboard and I'll click on it then sales details in pdf will open Please advise if there is an option for this , would really appreciate

Could you display 3d shapes (similar to a 3d pdf and rotate then) ?

Why to geolocate the shape if you never display the geolocation map, anyway to activate that as a base map?

Sir, can you make the starting part of this video easier to understand?

sir can you make more villas related videos

Thanks sir very informative video

Any idea on how to get rid of the 5k row limit? My snapshot has over 5k rows and I will break "Your 'Apply to each' action is encountering an error because it is trying to process more items than the maximum limit of 5000, with 5903 items being passed. This issue arises from the query results returning too many rows. To resolve this, could you consider filtering the query results to reduce the number of items returned, or perhaps implementing pagination to handle the excess items?"

This looks great. Excited to give it a try.

Thank you so much ❤ it works for me, however the texts are not clear enough even after zooming the contents

Hi, thank you for the awesome video, very informative. Please how did you add the score column to the Risks Status table, that section happen to have been omitted and my formula isn't working as a result

Excellent, easy to follow demo. Thank you!!!

This is fantastic video!!! Thank you so much! Can you please show how to create custom visual with GPT insite? Also would be great to learn if you could create charts with GPT prompts within Power BI service

Can I create a button in html and linked it with a bookmark?

Hey Great Video helped a lot, just one thing i am not able to get the Zero's in table as zeros are not there the rows and columns are hidden, what could be the possible reason??

Thank you for this, it was just what I needed. One quick question, though. When I want to add two different fields from two different lists, do I have to compile them into one in order to do that? When I tried, it only showed me the fields in the list I created the HTML code on.

Outstanding 😮

Custom visual links doesn't work on Power BI such as mailto:.. Instead of using custom visuals they should add rich text format in text box and maybe they did my version is bit old

Great! but how does it work with RLS to the same threshold for all users? Thank you in advance.

Hey see i am working on a Use case for my project : CRR Tuning. Tech stack : PowerBI, SQL Server (Onprem solution - strictly everything is on Onprem for security reasons binded with a Onprem gateway), PowerApps ( for writeback), Power automate (for dynamic flows/triggers). The Implementation we seek is: To provide the option to end users such that they create and select an snapshot of the reference tables ... to be precise for context we have 2 types of data ... a). reference data of Actimize risk factors b). static data - this is the action item score record wise to compute using the reference data. So here we need to carefully assess how best without any conflict work on a implementation that is scalable and reliable. Suppose they wish to create almost 40 snapshots of the reference data after there wishful changes done to the data using writebacks powered by PowerApps screen. Now the phase-1 is clear that we need to allow the users to have this option of creating snapshots [state of the reference datas tables backed-up as a historical visit or reference] ______ Now phase-2 is to bring these simulation as selected in PowerBI report such that they view the snapshot of static data scores using the reference data at that point of time while saving as simulation1 strictly all the recalculations should be done in sql server using sql queries itself (even the parameterization of queries) if needed. This should be read-only and we need to exit the simulation mode to continue making regular changes. Hey actually we wish to save both the reference data and static data configuration and outputs but due to constraint on storage we are left with storage of reference data itself as at day end the static scores are done calculating using reference data. Hey see the main thing that connects each phase is 1. First the user as usual views our report and makes all the changes in the reference data using writebacks through power app screen embedded as a visual in PowerBI. ---> This portion of implementation is done up and running completely, don't include in our solution walkthrough directly assume that this exists. 2. Now after all the changes are done, they will have an option to click on a button to save an snapshot (again we are not still sure how the data is saved for better retrieval). 3. Now once we have few snapshots created likewise, the end user will use the options and view snapshots in PowerBI and once they select a specific snapshot they should view the reference table data at that point of time ... this should be read-only and why this matters is because the static data scoring is dependent on reference data so new changed reference data means recalculation of these in sql server and updated visuals with new data. So in simple terms when we select that specific snapshot of reference data tables the whole report recalculates in sql server using sql query or inbuilt functionality based the static data scores change as the reference data as been modified with which we tend to calculate the static data scores. 4. This should be read-only and has to be able exit this simulation mode to normal mode where they can edit and continue with the snapshot creation and such. ___ X ___ A heads-up would be for you to learn and master and build some expertise on how to create a snapshot based off multiple tables data at once in one single changelog table corresponding to the snapshot we work. second heads-up being how to load selective data like if suppose snapshot 2 is selected then the data that is held by snapshot 2 should be used in the PowerBI Reporting which is different from our current data pre-selection.

Hi Hamzeh, I tried to follow same steps as you explained in this video. I am using OneDrive for data storing as you used google sheets. When I am trying to add a row to table using item(‘apply to each’)[‘table[project_name]’] , its colour is not Turning to yellow, it staying as purple. Could you please help in this regard. Thanks.

This worked great!! Thank you so much!

You now can encode base 64 right in Power Query and Power BI accommodates way more than 30k characters in the same column (2 tips right here), however from my experience visuals don't accept Base64 string over 30k characters - what is the trick here?

I recommend taking a look at the chatPowerBI visual (search on Google). I had better results in my use case

Hi, great video. thanks! One question: why are you using .cvs files instead of excel .xlsx?

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)?

many thanks for your increasable content. unfortunately, I used the same steps & same python code, but the result is df table is empty. Could you please help me in this regard.

This is an awesome tutorial buddy is there any ways to add Values which we make calculation in the dax to show as value ? if yes please help

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.

great video

Its really awesome 🌟

Hi excellent crisp presentation. I create Power BI reports, but so far was not using Automate, but one user needs forced me to look into it. Just saw your video, and replicated this very similar flow. It worked fine. There are few challenges, if you can help, 1. it skips rows if there is any column value is blank, how to still take those lines. 2. it transfer rows in batch of 100, and between such batch it takes time, can we avoid that? 3. Just for 2400 rows, it took 4 hours, too long? 4. where are the setting to change row count limits? By the way, one of the place is when you copy the DAX query, in query itself, 501 rows were written as TOPN limit, that I altered already. All help appreciated. Thanks.

Great Stuff! I was trying to modify it a bit to dynamically show boxes on left and right based on my column value from the table. For example - If the value in the column = "Drivers" then it should appear on the left side if the timeline and if it is "Restraints " then on right side. I tried chat gpt to add this functionality but its messing up the code. Can you help me out here? Also, one more issue i faced was if my milestone description is too long then the visual shows blank. Appreciate your valuable advice here!

what does your 'ref' column mean and what does it represent?

Very Help. Thanks a million for sharing

Great tutorial. I looked at several of these videos and this one is really well built.

dont use polyline and click 4 times...but use bpoly and select inside the lot and it will make a polyline for you....save time and clicks...

Can I get the quantity template directly from VCAD?

At 6:03 in the video, you wrote this Risk Status = 'Risks'[Risk Category] & " - " & 'Risks'[Consequence] & Risks[Likelihood] However, you verbally said to multiply which should look like the below: Risk Status = 'Risks'[Risk Category] & " - " & 'Risks'[Consequence] * Risks[Likelihood] Which one is correct as I am passionately building the dashboard with you as you speak?

Thank you so much for the best tutorial. ... great job!!