Great video! I think the most important and difficult part is the bridge table. Just a question I'm still struggling with, why din't you do a full outer join between "Bridge Table" and "Invoice_Details Bridge Base" using OrderID field?
Thanks! I think I did a union to because I needed to incorporate the changing ownership of the record. Which means I would have the order detail joined with header order fact table, and the same with the invoice tables, and then created a union between the two, allowing for the owner dimension to be able to filter for orders and invoices, but include related records that have a different owner. I don't think I had order ID in the invoice details tables, this was mainly an attempt to connect fact tables in a sales process where the ownership changes, yet still incorporate RLS.
This is a good technique. By the way, I downloaded the pbix file and tried adding a date filter (i.e., Year) from the Date table. I was expecting that the date slicer will filter the visual but it is not working at all, perhaps the relationship is inactive from date table going to the dimension tables. I tried making the relationship between date table to the dimension, but I got an error saying, "There are ambiguous paths...". How do you solve this problem?
Thanks! Date table is used to only filter the fact tables. It can filter dimensions perhaps through the fact tables via the bridge table. If you need the date table to filter a dimension table, it would probably require a different model. A possible way is to make sure the direction of the relationships from date table to fact to bridge to dimension table allows it to be filtered.
What if the fact tables are connected to the bridge table via unique dim keys per table? In other words, if there isn't a shared primary key in the bridge table, is it possible to link the fact tables via the unique dimkeys of the bridge table? This question is specific to enterprise environments connected via Live Connection without access to Power Query?
Hey, yes of course. I used the bak (database backup) file and a local SQL Server to set up the database. www.microsoft.com/en-us/download/details.aspx?id=18279
Thank but this is explained way to fast, way too fast. I have a real problem to connect sales with shipment and invoices and I am looking for solutions.
@@poweraegg Thank You very much for your attitude, I would appreciate it. The video is really nice but complicated. I am searching for solution for other type of model. I am having 3 fact tables: sales, invoices and shipment. I am just completely lost as this is my first model with such problems. Works fine when connected with order ID however it is not proper way and an I cant put many field into matrix (as there is "no connection" information popup. Really frustrating. I just can't figure out how transform You solution to my model
@@Wzxxx it is difficult to help out without seeing your case. However you can download the solution from Github, investigate the data model a little bit. Hopefully this will help 😊
Great video! I think the most important and difficult part is the bridge table. Just a question I'm still struggling with, why din't you do a full outer join between "Bridge Table" and "Invoice_Details Bridge Base" using OrderID field?
Thanks! I think I did a union to because I needed to incorporate the changing ownership of the record. Which means I would have the order detail joined with header order fact table, and the same with the invoice tables, and then created a union between the two, allowing for the owner dimension to be able to filter for orders and invoices, but include related records that have a different owner. I don't think I had order ID in the invoice details tables, this was mainly an attempt to connect fact tables in a sales process where the ownership changes, yet still incorporate RLS.
Great video! Very helpful thank you
@@rachidachaib-j8n thanks for watching!
This is a good technique. By the way, I downloaded the pbix file and tried adding a date filter (i.e., Year) from the Date table. I was expecting that the date slicer will filter the visual but
it is not working at all, perhaps the relationship is inactive from date table going to the dimension tables. I tried making the relationship between date table to the dimension, but I got an error saying, "There are ambiguous paths...". How do you solve this problem?
Thanks! Date table is used to only filter the fact tables. It can filter dimensions perhaps through the fact tables via the bridge table. If you need the date table to filter a dimension table, it would probably require a different model. A possible way is to make sure the direction of the relationships from date table to fact to bridge to dimension table allows it to be filtered.
What if the fact tables are connected to the bridge table via unique dim keys per table? In other words, if there isn't a shared primary key in the bridge table, is it possible to link the fact tables via the unique dimkeys of the bridge table? This question is specific to enterprise environments connected via Live Connection without access to Power Query?
Create a union between detail tables and then from that create a bridge table to incorporate all the detail keys
@@poweraegg Thanks so much! Really appreciate you covering a topic many avoid! Great stuff.
can you add data files
@@vikasomahajan you can upload data files into Power BI, yes ☺️
Can u share data set
Hey, yes of course. I used the bak (database backup) file and a local SQL Server to set up the database.
www.microsoft.com/en-us/download/details.aspx?id=18279
Ok
Gv
The
توت توت
I couldn't finish the video, but perhaps a different teaching technique could be more effective next time..
Thanks for the Feeback, what do you have in mind?
Platy
ए
Dtc r tcbryy
لامكمززردى
Okaxk no go ko
Lummm
ض٢
নহহহহজ্জ
Thank but this is explained way to fast, way too fast. I have a real problem to connect sales with shipment and invoices and I am looking for solutions.
Thank you for the feedback. I will try to find a better balance in the future 😊
@@poweraegg Thank You very much for your attitude, I would appreciate it. The video is really nice but complicated. I am searching for solution for other type of model. I am having 3 fact tables: sales, invoices and shipment. I am just completely lost as this is my first model with such problems. Works fine when connected with order ID however it is not proper way and an I cant put many field into matrix (as there is "no connection" information popup. Really frustrating. I just can't figure out how transform You solution to my model
@@Wzxxx it is difficult to help out without seeing your case. However you can download the solution from Github, investigate the data model a little bit. Hopefully this will help 😊
@@poweraegg Can You recommend any good forum I can present and disscus the problem. I don’t like the original MS forum
@@Wzxxx you can try the Enterprise DNA forum but I think you also need to sign up