I am trying to build a pivot table from the data model (Excel 2013 don't have full use of the Power Pivot tools but what's already in the data tab) I have 5 tables in power query loaded to the data model and my main raw data has a connection to all of them. For some reason my latest table is not making a proper connection. I'm not sure what's happening or why they won't connect! The only issue I have had is with the Absolute Values query. It is connected to the GL Report by User query by username, which is connected to the User Report by username, and I want the full name from the User Report from my table.
I feel like I'm not making sense, let me know if you need any clarification, this is driving me to the mad house!
Hi Jessica,
The User Report does not have a relationship with the Absolute Values table. If you delete the relationship between the GL by User Report table and the Absolute Values table and instead create a relationship between Absolute Values and User Report then your PivotTable displays the correct results. Of course removing the relationship may have a knock on effect to other PivotTables.
If so, maybe you can bring the Absolute value into the GL by user report in Power Query before loading to PP.
Mynda
Merged the queries and my life feels more complete and accurate now! Thanks so much for the advice, I really appreciate it!
