![RADACAD](/img/default-banner.jpg)
- Видео 553
- Просмотров 7 020 070
RADACAD
Новая Зеландия
Добавлен 30 сен 2013
RADACAD is all about helping YOU to get more insight from YOUR data. We publish videos weekly about using Power BI and AI in real-life day-to-day challenges of using these tools to help you to learn how to analyze your data and get more meaningful information using dashboards, reports, visualization in Power BI. And Also, learn how to step up and do predictive analytics using Machine Learning and use AI.
Reza and Leila are both Microsoft Most Valuable Professionals (MVP) focused on Power BI and AI, Power BI All-Star winners, and consultants and coaches at RADACAD.
We are book authors, and Our books are amongst the most popular in the market in the world of AI and Power BI, and you can access those from the RADACAD website.
We are also speaking at many events in-person all around the world, through this channel, you will know about where to find us next.
Through our channel, you can have access to tons of videos in the world of Power BI and AI, Subscribe now, we are here for you.
Reza and Leila are both Microsoft Most Valuable Professionals (MVP) focused on Power BI and AI, Power BI All-Star winners, and consultants and coaches at RADACAD.
We are book authors, and Our books are amongst the most popular in the market in the world of AI and Power BI, and you can access those from the RADACAD website.
We are also speaking at many events in-person all around the world, through this channel, you will know about where to find us next.
Through our channel, you can have access to tons of videos in the world of Power BI and AI, Subscribe now, we are here for you.
Duplicate VS Reference in Power Query in Power BI and Fabric Dataflows
When you work with tables and queries in Power Query and Power BI or dataflow in Microsoft Fabric, you can copy them through Duplicate or Reference actions. It has always been a question in my sessions and courses: what is the difference between these actions. The explanation is simple but very important to understand. Because when you know the difference, you will use it properly. In this video, I’ll explain what a Reference is and the difference between that and a Duplicate.
read my article about it here:
radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics
read my article about it here:
radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics
Просмотров: 291
Видео
Timesaving Tips to Create Polished Power BI Reports by Allison Kennedy Auckland Power BI & Fabric
Просмотров 59719 часов назад
This is the recording of August 2024 Auckland Power BI & Fabric user group session presented by Allison Kennedy Topic: Timesaving Tips to Create Polished Power BI Reports Getting your reports to look polished and professional is key - without this step it's unlikely people will take your report seriously. The little things make a big difference. Things like aligning the visuals, formatting the ...
Power BI Direct Lake Reframe What is it in Microsoft Fabric
Просмотров 740День назад
If you use the Power BI Direct Lake feature to connect to Microsoft Fabric Lakehouse or Warehouse, then Power BI reads directly from the Delta Lake tables. There is a process called Reframe, where Power BI keeps the most up-to-date data in the semantic model. This video explains what that is and what scenarios you might want to change it in.
Creating a Shared Dimension in Power BI Using Power Query Basics and Foundations of Modeling
Просмотров 1,7 тыс.День назад
For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to design a good performing Power BI model. I will be writing about some of the c...
Dynamic Row Level Security in Power BI with Manager Level Access
Просмотров 2 тыс.14 дней назад
If you want to apply dynamic Row-Level Security in Power BI so that everyone see their own data, but the manager see everything, here is an example that I showed you how you can do that. learn more about it from my blog article here:
Power BI Report Performance Tip Add Data Limit
Просмотров 2,1 тыс.14 дней назад
Add this quick performance improvement on visuals in your Power BI report to have a better performance when deadling with large number of data points.
Use Power Query Parameters to Make Power BI and Fabric ETL Dynamic
Просмотров 2 тыс.14 дней назад
Learn how you can use Power Query parameters to make the ETL and data transformation process dynamic inside Power BI solutions or Dataflow solutions in Microsoft Fabric. Read my article about it here for more information: radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
Convert Date Datatype correctly using Power Query in Power BI
Просмотров 1 тыс.21 день назад
Learn a quick and easy way to change the data type of Date values in the Power Query in Power BI Desktop or Power BI Dataflows or Fabric Dataflows using this short tip. learn more about it in my blog article here: radacad.com/flawless-date-conversion-in-power-query
Getting Started with Power Query in Power BI Desktop
Просмотров 99521 день назад
This video is for you if you are an absolute beginner to Power Query and don't know what it is or how to use it. In this video, I'll explain what Power Query is and how it works, and you will see a demo of it in Power BI Desktop. To learn more about Power Query, read my article here: radacad.com/get-started-with-power-query-movies-data-mash-up
Roles in a Data Analytics Team
Просмотров 2,3 тыс.28 дней назад
In the previous article and video, I explained the important factors in having a successful data analytics team. One of those aspects is the team, the people, and their roles. In this article and video, I will explain the roles involved in the data analytics project and the types of tasks and requirements for each role. Read the article about it here: radacad.com/roles-in-a-data-analytics-team
Building Data Analytics Team
Просмотров 1,3 тыс.Месяц назад
Recently, I did a presentation at a conference, and the topic was non-technical, unlike many other presentations that I do. I thought it would be helpful for you all to know about it, as I spent some time and gathered some information about it combined with the experiences I had with some of my customers. This article and video are split into two: this one will be about things needed to make a ...
Microsoft Fabric Glossary
Просмотров 1,5 тыс.Месяц назад
There are a lot of similar terminologies and words when working with Fabric. We have Data Lake, Delta Lake, OneLake, and Lakehouse, and the list continues. I found it confusing for some to understand the differences between them. Although explaining these terms and their differences requires many different blog articles, having one place for a quick definition for each can be helpful. Hence, th...
SCD Type 2 in Microsoft Fabric and Power BI
Просмотров 2,1 тыс.Месяц назад
In the previous video, I explained SCD (Slowly Changing Dimension) and its different types. In this video, I'll show you how to implement SCD Type 2 (one of the most common types) using Microsoft Fabric and Power BI. This article includes using Lakehouse, Dataflow, Warehouse, Data Pipeline, SQL Stored Procedures, Power BI Semantic model, and report in Microsoft Fabric. Get all the codes from my...
SCD Slowly Changing Dimension An Ultimate Guide
Просмотров 2,7 тыс.Месяц назад
If you want to use Power BI, Microsoft Fabric, or any other data analytics tools, one of the key concepts to understand when working with a data warehouse system is the SCD (Slowly Changing Dimension). I will do this in a series of at least two articles. The first one (this one) will be on the concept of what SCD is, its meaning, and its different types. Then, the next one will discuss how to i...
Copilot in Microsoft Fabric Warehouse Magic SQL
Просмотров 1,4 тыс.2 месяца назад
Microsoft Copilot is utilized in different technologies in Microsoft; in Microsoft Fabric, one of the places that you can use Copilot is in the Data Warehousing workload, which will guide you through your SQL commands and enhance your SQL coding experience. I’ll show you how the Copilot in the Data Warehouse works in this article and video. See the codes and get more information from my blog ar...
Power BI DAX Query View Updates June 2024 and Copilot Demo by Zoe Douglas
Просмотров 2,3 тыс.2 месяца назад
Power BI DAX Query View Updates June 2024 and Copilot Demo by Zoe Douglas
Power BI Default Semantic Model or Custom A guide for using in Fabric Environment
Просмотров 2,8 тыс.2 месяца назад
Power BI Default Semantic Model or Custom A guide for using in Fabric Environment
Find All Errors in All Columns using Power Query in Power BI
Просмотров 4,6 тыс.3 месяца назад
Find All Errors in All Columns using Power Query in Power BI
Time Travel in Fabric Warehouse Query Snapshots of the Data at Any Point in Time
Просмотров 1,1 тыс.3 месяца назад
Time Travel in Fabric Warehouse Query Snapshots of the Data at Any Point in Time
Button Slicer Enhancing the Power BI Visualization
Просмотров 4,1 тыс.3 месяца назад
Button Slicer Enhancing the Power BI Visualization
Fabric Power BI Auckland Usergroup 20240501 Daniel Marsh Patrick Deneb Viz in Power BI
Просмотров 1,1 тыс.4 месяца назад
Fabric Power BI Auckland Usergroup 20240501 Daniel Marsh Patrick Deneb Viz in Power BI
Delta Lake Table Structure Demystified in Microsoft Fabric
Просмотров 2,1 тыс.4 месяца назад
Delta Lake Table Structure Demystified in Microsoft Fabric
Mirroring Snowflake in Fabric Supercharged Analytics at No Extra Costs
Просмотров 2,1 тыс.4 месяца назад
Mirroring Snowflake in Fabric Supercharged Analytics at No Extra Costs
Reza Interview with the Microsoft Fabric Team Rick Xu
Просмотров 3794 месяца назад
Reza Interview with the Microsoft Fabric Team Rick Xu
Reza Interview with the Microsoft Fabric Team Meenal Srivastva
Просмотров 3714 месяца назад
Reza Interview with the Microsoft Fabric Team Meenal Srivastva
Reza Interview with the Microsoft Fabric Team Radhakrishnan Srinivasan
Просмотров 2784 месяца назад
Reza Interview with the Microsoft Fabric Team Radhakrishnan Srinivasan
Reza Interview with the Microsoft Fabric Team Faisal Mohamood
Просмотров 3674 месяца назад
Reza Interview with the Microsoft Fabric Team Faisal Mohamood
Fabric and Power BI Auckland User group recording - Fabric CAT Updates of Fabric Conference
Просмотров 1,2 тыс.4 месяца назад
Fabric and Power BI Auckland User group recording - Fabric CAT Updates of Fabric Conference
Reza Interview with the Microsoft Fabric Team Nellie Gustafsson
Просмотров 4215 месяцев назад
Reza Interview with the Microsoft Fabric Team Nellie Gustafsson
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?
Yes possible to use Python for orchestrating. However, this will give you a visual editor and monitoring etc, which can make things simpler to use.
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'
you can filter the slicer visual by a measure value if you want. I have another video about it in this channel.
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?
Explore meta, you can save intermediate steps result into a variable and use data from that variable in another transformation table
@@muralim6104 can you please share any related link or so, I don't know about Meta yet
you can create a reference from the tbl1, and then build tbl2 from there, I have written about it here: radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics
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.
You are welcome!
The custom semantic model that we create in a fabric workspace still uses VertiPaq storage right? Or is it using Delta Parquet?
custom semantic model is using Power BI Direct Lake (which reads from parquet files). You can however, create a custom semantic model which is import if you want.
@@RADACAD Sir, when we are creating semantic model using our fabric warehouse tables, what storage mode it is actually implementing then? Direct lake or Dual Mode?
@@sulaimanahmed013 the default and "new semantic model" option use Direct Lake but if you import data in PBIX and publish in Fabric workspace then it uses Vertipaq
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.
It is the same, this one (data limit) is easier to set up, that one is more configurable
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. DRLS when implemented correctly would mean the job of maintaining it will be on the data owner side.
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.
If you have a visual that returns thousands of rows (tables or matrix for example), something like this boost the performance up. Otherwise you are querying a part of the data that you probably won't see it is far down in the table and you would never scroll that far. Of course if you can maintain it using TOPN filter that would be more configurable, but just the fact of doing something like this is helpful very simple and straightforward.
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
I will have a video about that coming soon :)
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!!!
Glad it helped!
You are toooooo Good in Power BI 🙏🙏
Thanks :)
I'm wondering if this will impact the export functionality or is just for the visual
Thank very much form Thailand
Very nice ❤
Thanks 🤗
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 ?
that method can be used too. as long as it returns true/false in any way it should resolve correctly there
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?
Yes, correct RLS flows through the relationship and in the direction of the relationship. in the case of disconnected tables, you have to apply RLS filters on other tables too in the same role setup.
Thank you 😊
you're welcome
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
Absolutely Having some sort of txt message on the report will be needed to explain it. Thanks 😊
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 😊
For something like that I suggest using a measure and handling that using DAX and parameters instead of data limit.
If this new option is used, it does not allow the use of Using Visual Object Calculations
It is a very new feature, so I assume it gets blended gradually with other features
It can be used as to filter out the top/bottom items??
top items
Fantabulous video Reza
Thanks :)
million thanks, Sir.
Thanks :)
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.
Thanks for your kind words, I am glad you liked it.
What is Expand by
Great tip, thank you for sharing :)
You are so welcome!
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 👍🏽
Thanks :) Yes, Great weather in Melbourne these days. Cheers
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 .