Видео

How could I get theme txt file please? Thanks

Total beginner will learn something out of the session , unfortunately nothing new to what was already available 5 years ago.

Oh how did I miss this meetup with Alison?!! Cant wait to give this a watch - she is awesome!!!

I could not figure this out for the life of me, and you explained it perfectly. Thank you for posting this!

Need a video on role hierarchy data security

I've been a fan of this feature and it has greatly improved my workflow. One thing I haven'y wraped my head around is if I use dataflows gen 2, within the power query editor on the bottom right I can set where the data is being stored but this isn't the case with Gen1 dataflows so I wonder, where is the gen1 dataflow storing the data in this case? Thanks for your informal videos @Radacad love your content, keep up the great work!

Amazing video, but one important thing, when develop your dashboard using power bi desktop and connect to your semantic model, will use automatically import mode(Analysis Services), if you want to use direct lake mode, you have to develop your dashboard straight from fabric!!

Till now I coudn't understand properly what it'\s for. Would't be easier doind the same thing just with one python script?

working hard to find this method from last week f inaly u helped me coz i was unable to combine data which was combined before from differnt sourses

What about the formula if we use in direct query mode

Thank you, Reza, excellent content!

In some tables there's no data for a given product. How to not show this product in the slicer? Something like Excel's 'hide values with no data'

Will it work only in premium workspace or it will work in pro also?

Hi Raza, I have power query table called "tbl_1". I need to have another table called "tbl_2" sourcing data at "tbl_1" step no. 4. There are other steps also after step#4. I don't want to duplicate table because it was decrease its efficiency. How can it be achieved without duplicating table?

Great video, nice and easy explanation. Thanks for your creation. Just wondering that merging would be difficult to do as version control doesn't show the differences in a very meaningful way. Btw any video deployment pipelines in Power BI?

Great video, thanks.

The custom semantic model that we create in a fabric workspace still uses VertiPaq storage right? Or is it using Delta Parquet?

Thank you. Do you have any link available to download the sample files? It would be great to follow along while watching the video.

Gracias!!

What is then the difference between the existing Top N Filter? I am confused. Thanks.

Thanks for the video, although my "create new table" is greyed out :/

Love this approach! :) I was showing someone Dynamic RLS the other day and commented to them, a downside is that you have to manage who's in the manager group in security settings. This approach allows me to hand the job back to the data owner.

Thanks for highlighting this new feature. I'm struggling to see a practical use case for it though. Except for perhaps speeding up development, ie adding a temporary data limit when working with visuals that might take a while to render. Especially seeing as there doesn't seem to be any control over what the TopN is sorted by. For instance in the example, it's alphabetical customer name rather than the measure. Would I be right in thinking that you'd be better of either using a TopN filter on the visual if available or using a TopN measure? If you make the TopN measure dynamic, the report user can control what they see and it would be more transparent as to what was happening.

Hi Sir, I have one question, I have similar use case however, i have a table with many to many relationship. can RLS work in many to many set up ? here you are forming one to many relationship which is working for me. I have tried to create a bridge table with just the common column. but still it does not work

Hello Reza, thank you very much for your explanation. Unlike your process, when I check "Enable Staging" I have to select a staging account connection, which you didn't need to do. Is this a new requirement, or did I set something up differently? Thank you.

This took so much pain away from me!!! Thank you!!!

You are toooooo Good in Power BI 🙏🙏

I'm wondering if this will impact the export functionality or is just for the visual

Thank very much form Thailand

Very nice ❤

Thanks for the video. When no username is found, to avoid showing all the information or modifying the code, isn't it a solution in the LOOKUPVALUE function to set the <alternateResult> to 0 ?

Nice video and explanation. Suppose we had a table with information that was not connected via relationships in this case not connected to sales rep, like a disconnected table. In such a case RLS will not apply and we have to address it separately?

Thank you 😊

Since the data limit feature only displays a subset of the data in ascending order by default, there is a significant risk that users may not see the full dataset. This can lead to incomplete analysis, where assumptions or decisions are based on partial data. Users who are unaware of the applied data limits might also question the accuracy and integrity of the report, potentially leading to a loss of trust if they believe the data has been manipulated or truncated. Thus, education and guidance should go hand in hand with the implementation of this function

Can’t we have both dynamic RLS and dynamic subscriptions

And how do I add a navigation button to retrieve the next 15 records as shown in the example? Is this the pagination feature? Thanks 😊

If this new option is used, it does not allow the use of Using Visual Object Calculations

It can be used as to filter out the top/bottom items??

Fantabulous video Reza

million thanks, Sir.

Hi, you always post very very informative videos. One Que. I have an Excel365 file which has data from the odbc connection, which updates automatically in scheduled intervals, how can I sync that Excel data into Google Sheets with auto updates? Please Help.

👍 Thanks Leila

I've been using ArcGIS Pro for plotting basic maps, also have PowerBI, is it possible to use ArcGIS Pro Map in PowerBI. Could you recommended any course primarly focus on Maps in PowerBi. Thanks

Thanks for the video Could you please explain more about the part inside the measure? Here I mean factinternetsales

How can I not subscribe? I think the secret to exceptionally good videos, like this one, is not assuming what the viewer knows. Also the presentation is excellent with highlighting the relevant buttons / tabs. 10/10. Power BI is great for this, I used to do profiling in Excel, having to eyeball through hundreds of columns.

What is Expand by

Great tip, thank you for sharing :)

It does make sense to decouple the subscription from the report access for cases where we want to provide only the PDF but not share the report. Especially when the RLS is set on a dimension different from the one dynamic subscription is being set with. Thanks so much Reza, this is a very helpful video!

Thanks Reza and hope you're enjoying the sudden great weather in Melbourne! PBI has so many tiny tools that you can't always find/know about until someone points it out. Thanks 👍🏽

New MTD Sales LY = VAR CurrentDate = MAX(V_Calendar[SetDat]) VAR CurWrkDay = MAX(V_Calendar[MonthlyWrkDay]) VAR RepMonth = MAX(V_Calendar[CokeMonth]) VAR CurYear = YEAR(CurrentDate) VAR PrvYear = CurYear-1 VAR TotalWrkDayInCYMonth = MAXX(FILTER(ALL(V_Calendar) , V_Calendar[CokeYear]=CurYear && V_Calendar[CokeMonth]=RepMonth),V_Calendar[MonthlyWrkDayNum]) VAR TotalWrkDayInPYMonth = MAXX(FILTER(ALL(V_Calendar) , V_Calendar[CokeYear]=PrvYear && V_Calendar[CokeMonth]=RepMonth),V_Calendar[MonthlyWrkDayNum]) VAR RepDay = IF((CurWrkDay>=TotalWrkDayInPYMonth), TotalWrkDayInPYMonth, CurWrkDay) VAR mSartOfMonth = MINX(FILTER(ALL(V_Calendar) , V_Calendar[CokeYear]=PrvYear && V_Calendar[CokeMonth]=RepMonth),V_Calendar[SetDat]) VAR mEndOfMonth = MAXX(FILTER(ALL(V_Calendar) , V_Calendar[CokeYear]=PrvYear && V_Calendar[CokeMonth]=RepMonth && V_Calendar[MonthlyWrkDayNum] <= RepDay),V_Calendar[SetDat]) RETURN CALCULATE(([Sales PC]), V_Calendar[SetDat] >= mSartOfMonth && V_Calendar[SetDat] <= mEndOfMonth) Here is the formula but calculation for pervious Year MTD come for full Month , Like this year we are taking report upto 11-Aug-2024 but Previous year MTD come for full month. Please advise where is the issue .