Hi,
If I load a table into power query and save to data model and then open in power pivot, then add to a pivot table
in the Pivot table fields box I have two tables, is there a way around this I found the same question being asked on MS site
but there wasn't really any solution, just they didn't have the problem.
I've attached the workbook, showing one Table in power pivot, one in excel, source, and two in the pivot table fields.
Richard.
Bookmarks