Forum Discussion
Two Attribute Fields From Same Table in a Table Vis _ Second Attribute is Blank
Hi,
I have a sort of Medallion Architecture in Power Query
1. Table 1 - Connect to data
2. Table 2 - Ref Table 1 and do some transformations
3. Table 3 - A few final transformations
I can see Account and inventory in Table 1 when I enable the load and throw a few fields in a table vis
I can see Account and inventory in Table 2 when I enable the load and throw a few fields in a table vis
But when I get to table 3, I cannot see inventory
There are no slicers or filters impacting the vis.
I checked table 3 in Power Query, I can see the inventory for the account.
What might be something else to check as to why I cannot see inventory in the table visual?
Thanks,
w
v-pnaroju-msft
I really think there is some kind of corruption in the old workbook.
I created a new workbook
I opened each table in the old in Power Query >> Advanced Editor
I copied
I went to the new workbook >> added a new blank query >> opened in Advanced Editor >> pasted in the query.
I updated anywhere where I changed names and continued until there were no errors in each of the queries.
I added the dimension table for Accounts based on the Bronze Table
I added the relationship from dim Accounts to the 3 fact tablesI added a table visual to to 3 different sheets and added the columns from the different fact tables
and added the Accounts as a slicer on each sheet.
Everything works exactly as expected so Accounts and Inventory is now in all tables.
I added all other queries (39) and tested at each step
Everything is working as expected except 1 measure because we have 75 rows missing unique id's in data coming from Snowflake.Thanks,
w
6 Replies
tecumseh Sorry, a bit confused. These are tables or table visuals or both? If a table visual for Table 3, assuming that you put the Inventory column in the visual, are you just seeing blanks or ?
Sorry, this is confusing. What columns/data did you load? Does Table 3 have the inventory data? Are there supposed to be relationships between these tables? Please read this: https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
danextian GeraldGEmerick
Here is a simple diagram to try to explain.
Seems very odd that I cannot see the inventory in the Table on Sheet 3
There are no measures and just one slicer to filter by the account. Same Slicer that is on Sheet1 and Sheet 2
Thanks,
wThankyou, GeraldGEmerick and danextian for your responses.
Hi tecumseh,
Thankyou for the update.
Based on my understanding, although Inventory is visible in the Gold table in Power Query, Power BI visuals and slicers operate solely through model relationships and filter context. In the Gold layer, the Account slicer may not propagate filter context correctly due to either an inactive or incorrect relationship, the slicer being sourced from a fact table rather than a dimension table, or a grain mismatch introduced by aggregation in the Gold table, wherein Inventory is no longer unique per Account and consequently evaluates to BLANK. This is the reason Inventory appears in Bronze and Silver (row-level data) but not in Gold (aggregated or reshaped data).
A possible approach is to ensure that the Account slicer originates from a proper dimension table, that the Gold table maintains an active relationship to that dimension with the correct cardinality and cross-filter direction, and that Inventory is either aggregated or modeled as a measure if the Gold table is at a higher grain.
Additionally, please refer to the links below:
Model relationships in Power BI Desktop - Power BI | Microsoft Learn
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft LearnWe hope the information provided helps to resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.
v-pnaroju-msft
I really think there is some kind of corruption in the old workbook.
I created a new workbook
I opened each table in the old in Power Query >> Advanced Editor
I copied
I went to the new workbook >> added a new blank query >> opened in Advanced Editor >> pasted in the query.
I updated anywhere where I changed names and continued until there were no errors in each of the queries.
I added the dimension table for Accounts based on the Bronze Table
I added the relationship from dim Accounts to the 3 fact tablesI added a table visual to to 3 different sheets and added the columns from the different fact tables
and added the Accounts as a slicer on each sheet.
Everything works exactly as expected so Accounts and Inventory is now in all tables.
I added all other queries (39) and tested at each step
Everything is working as expected except 1 measure because we have 75 rows missing unique id's in data coming from Snowflake.Thanks,
w
Hi tecumseh,
Thank you for the update and for sharing the details.
We are pleased to know that everything is functioning exactly as expected. Please continue to utilise the Microsoft Fabric community for any further queries.
Thank you.
