Forum Discussion

tecumseh's avatar
tecumseh
Icon for Resolver III rankResolver III
7 months ago
Solved

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 se...
Need Help
  • tecumseh's avatar
    tecumseh
    7 months ago

    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 tables

    I 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