Відео

Your videos are very informative

Great video! Do you have an account on: paid sliderrevolution?

Thanks for the video. I was wondering if you could write what you pasted at the 8:14 to get the colours for the matrix? What you pasted in is very small on screen. Thanks

Hello, thanks a lot for this video, helps me a lot. But when I “Run a query against the dataset” action it returns “BadRequest” according to Current Date, which I also used in my DAX querry. I create column Current Date, publish report and copy DAX querry as you show in video. After run I received error "value": "Query (10, 4) Column '<oii>CurrentDate</oii>' in table '<oii>view_production_plan_values_shift</oii>' cannot be found or may not be used in this expression." } }, { "code": "AnalysisServicesErrorCode", "detail": { "type": 1, "value": "3241803780" } Do you know where can be problem? Thanks a lot...

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 can display PDF file in the report as it is: ua-cam.com/video/TEou0LuPjkA/v-deo.html

Amazing video, how can I get the Python code? Thanks!

Is it possible to automate this manual process using Alteryx

I believe that using synoptic design is a bit simplier

Hi NextGenBIGuru, it's been a long time since you posted your last video. Are you OK Sir.

This is great, however I just get a blank black box......

hi. could you lead me to the python script? It seem to be unavailable on the link in the description. thank you

Hi, Thank for the video. It work fine when PDF size is small like 4 page n so, but when pdf size increased to 30 page, converting it to base64 result value in column from a to ce length in excel. Later when command in power bi (BAse64pdf = ts[a] to ts[ce]) power give back error (Function 'PLACEHOLDER' encountered a Text that exceeds the maximum allowable length.) do you have any solution for this

Greetings from Ecuador. Could I customize the ID for each polygon?

In fact, I did the risk matrix, but I had a problem: the risk matrix should cover all levels of impact and likelihood (row headers and column headers); otherwise, the heat map does not contain all levels. I do not know what the problem is.

I would like to know how to calculate the Ref column.

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