Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am working from 2 SQL server sources using DirectQuery. In SQL server A, Event_ProductID is an integer, and in SQL Server B, "productID" is a string but it should be a matching field between the two and it did allow me to make a 1 (product table) to many (event table) relationship, but it's not letting me create visuals with both of these tables contributing columns.
The 'Product' table comes from SQL server A and has the following columns:
Cost, Name, productID
The 'Event' table comes from SQL server B and has the following columns:
EventOwner, Event_ProductID, Event_SessionName, Event_Location
I was thinking i could maybe make a new table with productID, name, EventOwner and Event_SessionName and use that for my visualisations but the RELATED function doesn't seem to be working and I'm a bit stuck at this point.
Any advice on how to make a new table referencing both these tables and converting productID to an integer on the fly?
Solved! Go to Solution.
What I was really looking for was the function LOOKUPVALUE. All sorted now, thanks!
What I was really looking for was the function LOOKUPVALUE. All sorted now, thanks!
@Anonymous
For many to many relationship, only RELATEDTABLE function (DAX) - DAX | Microsoft Docs function. If you want to use RELATED function (DAX) - DAX | Microsoft Docs, you may create a mid table using distinct([column]), then link both tables to the mid table with 1 to many relationship.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@Anonymous , if the product ID is not unique in one of the tables you will get M-M to join. You can have a table in import mode (composite mode) and use that. Create a product table in import mode and use that with both databases.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |