Power BI Relationships Not Working? Four Steps to Debug 🐞 for the Power BI Beginner

Подписаться 201 тыс.

Просмотров 46 тыс.

50% 1

Are your Power BI Relationships not working? It can be so frustrating when that happens. The good news is that the four steps shown in this video will help you debug most of your Power BI Relationships problems.
00:00 Introduction
01:05 Tip #1 Debug Using Simple Table
02:03 Tip #2 Debug Using Simple Measure
04:05 Debug #1 Is there a Relationship?
05:34 Debug #2 Is Relationship Active?
06:15 Debug #3 Direction of Relationship?
07:51 Debug #4 Data Type
09:31 Next Step: Specific Values Missing
Part 2 Video: Missing and Blank Values
• Power BI Relationships...
Part 3 Video: How to Add Missing Values Yourself
• Power BI Relationships...
Ultimate Calendar Download Video
• Power BI: The Ultimate...
================================
#PowerBI #_______________ #PowerBIPro
👉 FREE Power BI Step-by-Step Tutorial web.learnpowerbi.com/tutorial
👉 Download Accompanying PBIX Files for Video at web.learnpowerbi.com/download/
✅ Subscribe to always get my latest videos: ru-vid.com?su...
🔴 Ask Questions LIVE on TalkPowerBI www.TalkPowerBI.com
👪 Join our LearnPowerBI Family www.learnpowerbi.com/training
===Most Popular Playlists===
• Power BI Beginner Tutorial: • Power BI Tutorial From...
• Ultimate Calendar: goo.gl/pyki4K
• Power BI Data Modeling and more: goo.gl/WNtJFv
⚡Power On!⚡
-Avi Singh
www.LearnPowerBI.com
www.AviSing.com

Опубликовано:

24 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 33

@eMJeyCGN 3 года назад

Would be great to have additional videos on that topic. Relationships is something I struggle most

@PowerBIPro 2 года назад

Hi , Checkout the Part 2 in that series here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-37kTdyo4OOc.html #Robert (team Avi)

@konteakurrodu5439 4 месяца назад

@@PowerBIPro Hi sir small doubt I'm new to power bi I'm doing one task I have connected table1 column filename to table2 filename and table3 filename columns with many to one relationship (two connections) In my report already i have same tables and bar After connecting the relationships In report view i have 3 tables If i filter any data by using text filter I'm able to get data in two tables but I'm not able to get in 1 table it showing empty why? and how to resolve? Both all the columns data types is text only

@mandyberglund7811 Год назад

#4 is what I needed!!

@muzinkuhlu2592 Год назад

This was sooo helpful.. many Thanks

@julie_chen 2 года назад

Avi, again you have saved my day. I am just starting out on Power BI.

@PowerBIPro 2 года назад

Great to hear! ^RM

@kiasca3489 Год назад

OMG you are a life saver, my relationship was pointing out to the right side but when I try what you says to edit relation ship it wasnt even referencing the column that it shouldnt be, I guess names or any null was getting a coincidence on month instead of sup column😭tkns.

@agbomary878 Год назад

Thank you Avi. This has saved my day

@PowerBIPro Год назад

Glad it helped!

@christinaguggenberger6061 2 года назад

Looking very much forward to the next video covering the fifth step!

@PowerBIPro 2 года назад

Hi Christina ,We did release Part 2 in that series here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-37kTdyo4OOc.html

@christinaguggenberger6061 2 года назад

@@PowerBIPro Thank you! I discovered Part 2 only after writing my comment 😃

@Erik-ie3xz Месяц назад

#4 just Saved my life

@santoshatyam1409 2 года назад

I have a table visual if I add a new column to this from another dimension it is giving like cross product with the present rows how to rectify it?

@captaiincold6275 5 месяцев назад

MAN YOU ARE THE HERO , you earned yourself a subscriber LOVE YOU

@kudratilla 2 года назад

What type of graph is Avi using in 01:05? i mena the stacked bars, they look great. where can i download this visual?

@PowerBIPro 2 года назад

That's a Ribbon Chart. It is included with Power BI latest version. Be careful though :-) Sometimes simpler is better (like a simple Column/Bar chart). Power On! / Avi

@praveenmullamuri2835 2 года назад

Hello Avi Singh Have fact table and dim date, in fact table nine date columns relationship was b/w the tables , how to find the time interval difference multiple date columns

@PowerBIPro 2 года назад

This is a good question. Kindly send it to- avi@avising.com and we will try and respond from there . Also include as much detail as possible. Here is an article on how to get your Power Bi questions Answered. ----> www.linkedin.com/pulse/how-ask-good-power-bi-questions-get-them-answered-singh-powerbipro-/ ^RM

@excelworx8712 3 года назад

waiting for the next video

@christianmalbeuf476 3 года назад

Would love to see the fifth method!

@PowerBIPro 3 года назад

Hey Christian, Yeah that problem is a slightly different bag but can be equally frustrating. The common things I have seen (and plan to cover in the next video) are: a) Extra Characters in the "Data Table" or "Lookup Table" field values. Typically this can be spaces or something. Usually happens when using "Text" type fields to connect the tables. For e.g. in the Data Table it would have "Red" as Color, but the Lookup Table would have "Red " (Red with a space) and of course they would not match b) Lookup Table Could be Incomplete: e.g. there are values in the Data Table that are not in the Lookup Table. e.g. Data Table has Colors: Red, Blue, Green, Yellow Lookup Table only has Colors: Red, Blue, Green (Then the "Yellow" numbers are all going to end up in a Blank Label c) Lookup Table does not have the Range of Values: This is similar to above but typical for Calendar Table. e.g. Your Data Table has dates from Year 2000-2021 But your Calendar Table only has dates from 2010-2021 Then all data from years 2000-2009 are going to end up in the blank bucket. There might be other scenarios that I think of (or that others suggest). I'll include all of them in the next video :-)

@bridgetmohring 5 месяцев назад

I would like to see the next video

@jholdsworth2218 2 года назад

When will the next video be coming Avi ? :)

@dcpowered Год назад

Can we please have more videos to help with relationships? Thank you so much!

@PowerBIPro Год назад

Hey Shakeel, We cover relationships in detail in our full Power BI Training course www.LearnPowerBI.com/training If you run into specific issues with Relationships let us know and we would try to help. Power On! / Avi

@miftak2759 Год назад

Hi i have this issue The query referenced column 'TExportDataMS_Daily'[_MT] which depends on another column, relationship or measure that is not in a valid state. Additional information: ''. Please try again later or contact support. If you contact support, please provide these details. Anyone help me please..

@tiktik5928 2 года назад

How to do index match in dax

@Aoekin 3 месяца назад

welp looks like it's my measure, still a weird reason to error, wish they had better error or debugging for this to figure out exactly what causes it.

@konteakurrodu5439 4 месяца назад

Hi sir small doubt I'm new to power bi I'm doing one task I have connected table1 column filename to table2 filename and table3 filename columns with many to one relationship (two connections) In my report already i have same tables and bar After connecting the relationships In report view i have 3 tables If i filter any data by using text filter I'm able to get data in two tables but I'm not able to get in 1 table it showing empty why? and how to resolve? Both all the columns data types is text only